Roadmap
Day 21 · Smarter queries 49 min 40 XP
🧩CASE & subqueries
Two tools take you from basic queries to real analysis: CASE builds your own categories, and a subquery lets one query use the answer of another.
What you'll learn
- Create labels with CASE WHEN
- Use a subquery inside WHERE
- Count conditionally with SUM(CASE ...)
A peek inside
CASE: if this, then that
The rest of Day 21 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: Label, compare, rate
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in