[Solved] Identify the error in this query:SELECT category, COUNT(*) FROM products HAVING COUNT(*) > 10 GROUP BY category; | SQL

SQL - GROUP BY and HAVING

Identify the error in this query:

SELECT category, COUNT(*) FROM products HAVING COUNT(*) > 10 GROUP BY category;

AMissing WHERE clause before HAVING

BHAVING clause used before GROUP BY

CCOUNT(*) cannot be used in HAVING

DGROUP BY should be replaced with ORDER BY

Step-by-Step Solution

Solution:

Step 1: Check order of clauses in SQL
The correct order is GROUP BY first, then HAVING.
Step 2: Identify incorrect clause order
The query places HAVING before GROUP BY, causing syntax error.
Final Answer:
HAVING clause used before GROUP BY -> Option B
Quick Check:
GROUP BY before HAVING [OK]

Quick Trick: GROUP BY must come before HAVING [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this query: