CptCruiser
New member
0
0%
3
Months of Service
0%
I have an assignment due tomorrow, but the questions seem very difficult to me. I would be very happy if you could help me. Table Structures Questions: 1) Group the shopping purchases made by customers without discount rights according to product categories. 2) On which dates were the most sales of refrigerators and deep freezers made? 3) How many different product categories has the customer who made the most purchases shopped in? 4) Who is the youngest customer who shopped in the most categories? 5) From which product was the highest sales amount obtained? 6) From which customer was the lowest sales amount obtained? 7) What is the average amount spent by customers who buy at least two products on the same date? 8) List the customers who shopped on Friday. 9) List the dates where no sales were made.