[Solved] Find the mistake in this SQL query:SELECT department, COUNT(*) FROM employees WHERE COUNT(*) > 10 GROUP BY department; | SQL

SQL - GROUP BY and HAVING

Find the mistake in this SQL query:

SELECT department, COUNT(*) FROM employees WHERE COUNT(*) > 10 GROUP BY department;

ACOUNT(*) cannot be used in WHERE clause

BGROUP BY should come before WHERE

CCOUNT(*) should be replaced with SUM(*)

DNo mistake, query is valid

Step-by-Step Solution

Solution:

Step 1: Understand WHERE limitations
WHERE filters rows before aggregation and cannot use aggregate functions like COUNT.
Step 2: Correct clause for aggregate filtering
HAVING should be used to filter groups based on COUNT(*) > 10.
Final Answer:
COUNT(*) cannot be used in WHERE clause -> Option A
Quick Check:
Aggregate functions not allowed in WHERE = A [OK]

Quick Trick: Use HAVING, not WHERE, for aggregate filters [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this SQL query: