Roadmap
Day 54 · SQL exploration 70 min 40 XP
🗄️Capstone: explore with SQL
With a clean table you can ask questions fast. SQL is the best tool for the first pass: counts, totals and rankings. You also add two tools beyond Season 1, a CTE and the LAG window function, to measure change between months.
What you'll learn
- Load clean_orders.csv into SQLite
- Answer the brief's questions with GROUP BY, JOIN and HAVING
- Compare months with a CTE and LAG
A peek inside
Load the data
The rest of Day 54 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Explore the shop in SQL
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in