Recall
Set 1: Quick Check
Choose GROUP BY and HAVING to establish and filter summary grain.
Grouping and Filtering Summaries
Control summary grain with GROUP BY and distinguish WHERE from HAVING.
Start Chapter PracticeChapter plan
What you will be able to do
- Build grouped summaries and reconcile their totals.
- Study time
- 28–34 minutes, self-paced
- Course
- SQL for Data Analysis (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Group multiple dimensions, separate WHERE from HAVING, and reconcile totals.
Hands-on
Set 3: Workplace Task
Summarize revenue by status and filter sales-rep groups in SQL.
Independent check
Set 4: Mastery Check
Diagnose an undefined grouped column and independently filter material revenue groups.