question

BOBEE avatar image
BOBEE asked

how to find the range and how to do mapping between tables

[[link text][1]][1] [1]: /storage/temp/2934-sales-table.docx
homeworkcase-statementbetween
sales-table.docx (12.6 KiB)
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I noticed this is your third question, and they are all homework questions. I looked at the document, but you only manually calculated a result. If you can show us what SQL you have written and explain where you are struggling, we can help you. We prefer not simply doing someone else's homework.
0 Likes 0 ·
Hi Tom,Thanks for your feedback,actually I am not looking for an answer ,I am new to SQL,I felt this question as a complex one.I am able to calculate it manually,but I don't have any idea that how to implement it in SQl,I just need an initial start about which concept I can use here .I don't know how to split 5 (qty) = (1-3) and (4-5) in order to check the range in price table.
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.