Challenge: Shop Reports
Use everything you have learned. Each query answers a business question. Run them, then change them to answer your own.
Which customers are from London and over 30?
Examplesql
What is the best-selling product by units?
Examplesql
How much has each city spent, highest first?
Examplesql
Now write your own: list products that nobody has ordered. (Hint: LEFT JOIN from products to orders and check for NULL.)
Examplesql
Quick check
Which clauses would you need to find the total spent per customer?
Your turn: write the code
Which product has the highest total quantity ordered? Return just its name.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.