SQL - GROUP BY and HAVING
Which SQL clause correctly filters groups where the number of orders exceeds 5?
Which SQL clause correctly filters groups where the number of orders exceeds 5?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recognize filtering on aggregate functions
Filtering groups based on aggregate functions like COUNT requires HAVING.Step 2: Eliminate incorrect clauses
WHERE cannot filter on aggregates; GROUP BY and ORDER BY do not filter groups.Final Answer:
HAVING COUNT(*) > 5 -> Option AQuick Check:
Use HAVING for aggregate filters [OK]
Quick Trick: Use HAVING to filter groups by aggregates like COUNT [OK]
Common Mistakes:
MISTAKES- Using WHERE with aggregate functions
- Misusing GROUP BY as a filter
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes