Checkpoint: the online shop
A checkpoint on joins. Five questions across an online shop's customers, products, orders and order lines, from LEFT JOIN to three-table revenue.
- The skill
- Answer shop questions that need several joins, on your own.
- You make
- Five reports for an online shop, from revenue per city to a refund bug.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 16 Joining a table to itself. Free to try: SQL Foundations and the playground.
Cleared
Go back to
You can now
Step 1 of 6
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite