WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

Please Help with SQL Assignment

CptCruiser

New member

0

0%

Status

Offline

Posts

35

Likes

0

Rep

0

Bits

185

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.
 

249

6,622

6,642

Top