Roadmap
Day 19 · Grouped summaries 49 min 40 XP
🗂️GROUP BY & HAVING
A single total is useful; totals per category are where insight starts. GROUP BY splits rows into buckets and runs your aggregate on each bucket.
What you'll learn
- Summarise per group with GROUP BY
- Filter groups with HAVING
- Explain the difference between WHERE and HAVING
A peek inside
One row per group
The rest of Day 19 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: Group the orders
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in