SQL - GROUP BY and HAVING
Choose the correct way to filter grouped results using the HAVING clause:
SELECT city, COUNT(*) FROM customers GROUP BY city _______ COUNT(*) > 10;
Choose the correct way to filter grouped results using the HAVING clause:
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Understand filtering groups
TheWHEREclause filters rows before grouping, so it cannot filter aggregated groups.Step 2: Use HAVING for group filters
TheHAVINGclause filters groups after aggregation, so it is the correct clause to use here.Final Answer:
HAVING -> Option CQuick Check:
Filtering groups requires HAVING clause [OK]
Quick Trick: Use HAVING to filter groups after aggregation [OK]
Common Mistakes:
MISTAKES- Using WHERE instead of HAVING for group filters
- Placing HAVING before GROUP BY
- Using FILTER keyword which is invalid here
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes