Joining Three Tables
Chain joins to follow the links: orders point to customers and to products. Here is a full order report.
Examplesql
Joins combine happily with GROUP BY. Total spend per customer:
Examplesql
Quick check
To use data from three tables in one query you...
Your turn: write the code
For each customer who ordered something, return their name and the total quantity they ordered, sorted by 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.