Complete HAVING Clause
Fill in the Blank Medium
Question
Fill in the blank to keep only groups with more than 5 orders:
Code
SELECT user_id, COUNT(*) FROM orders
GROUP BY user_id
___ COUNT(*) > 5;
Hint
This is like WHERE but for groups, after aggregation.
Explanation
HAVING filters groups after GROUP BY. Unlike WHERE (which cannot use aggregates), HAVING can reference aggregate functions like COUNT, SUM, and AVG.
Related Resources
Related Lessons
- GROUP BY
Learn HAVING.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.