Roadmap
Day 18 · Aggregates 42 min 40 XP
🧮COUNT, SUM, AVG, MIN & MAX
Analysts rarely read single rows. They summarise. Aggregate functions squash many rows into one number: how many, how much, on average, smallest and largest.
What you'll learn
- Use the five core aggregate functions
- Know how NULL and DISTINCT affect a count
- Multiply columns inside a SUM to get revenue
A peek inside
The five functions
The rest of Day 18 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: Five numbers about the shop
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in