In this video, I'm going to walk through a database and run some SQL queries to find the answers to business questions. I query SQL in MySQL database management system. The business questions are:
Print details of sales where amounts are greater than 2,000 and boxes are less than 100
How many sales did each of the salespersons have in January 2022?
Which product sells more boxes?
Which product sold more boxes in the first 7 days of February 2022?
Which sales had under 100 customers & 100 boxes? Did any of them occur on Wednesday?
Comments