Given this criteria will somebody help in the query to accomplish this?
Table A contains the weekly price of lemonade at the local restaurant.
Table B contains the weekly price of lemonade as the supermarket.
Table C contains every student at the local school and their lemonade allowance which never changes.
A student will always buy the most expensive lemonade within their budget.
Write a query that will provide the total number of lemonades sold by the restaurant and the supermarket each week.
Here is the sample data per table:
Table A
Week ---- Price
1 ------- $1.00
2 ------- $2.00
Table B
Week ---- Price
1 ------- $2.00
2 ------- $3.00
Table C
Student ---- Allowance
Bill ------- $1.50
Sally ------ $2.75