question

BOBEE asked Oct 14, '15

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

[[link text][1]][1] [1]: /storage/temp/2934-sales-table.docx

sales-table.docx (12.6 KiB)

10 |1200

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

Tom Staab ♦ commented · Oct 14, 2015 at 05:08 PM

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 ·

BOBEE commented · Oct 15, 2015 at 07:13 AM

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 ·