- Executors
-
Learn
Learn Python Runnable examples, NumPy, pandas, and more Learn AI / Machine LearningNeural networks, ML and LLMs from scratch Learn C & C++ Pointers, memory, STL, and modern C++ Learn C#C# basics, OOP, LINQ, async, and .NET exercises Learn MatplotlibLine, bar, scatter and pie charts with live visualizers Learn RustOwnership, traits, error handling, and threads Learn GoSlices, interfaces, goroutines, and channels Python Algorithms Search, sorting, recursion, and visualizers O(n) C & C++ Algorithms Compare algorithms implemented in C and C++ Coding for Kids Learn to code by playing!
- QuizzesNew
- ChallengesNew
- For TeachersNew
- Updates
- Buy me a coffee
Aggregates & GROUP BY Quizzes
Summarize data with SQL: count, total and average rows with aggregate functions, group them with GROUP BY, filter groups with HAVING and handle NULL along the way.
Beginner
5 quizzes · 50 questions
about 29 minutes
0/5passed
Category exam
20 mixed questions. 80% earns a certificate.
1
COUNT, SUM, AVG, MIN & MAX
Easy
Turn many rows into one number with the five core aggregate functions.
#aggregates#select
10 questions · ~5 min
Not started
Start
2
GROUP BY
Medium
Split rows into groups and calculate a total, count or average for each one.
#group-by#aggregates
10 questions · ~6 min
Not started
Start
3
HAVING
Medium
Filter groups by their totals, counts or averages after GROUP BY.
#having#group-by
10 questions · ~6 min
Not started
Start
4
COUNT(*) vs COUNT(column)
Medium
Know exactly what each form of COUNT counts, and why NULL changes the answer.
#aggregates#null
10 questions · ~6 min
Not started
Start
5
Aggregates & NULL
Medium
See how SUM, AVG, MIN and MAX skip NULL and what they return when nothing is left.
#aggregates#null
10 questions · ~6 min
Not started
Start
No quiz matches. Try another word or tag.