[Solved] Identify the error in this SQL query:SELECT department, COUNT(*) FROM employees WHERE department GROUP BY department; | SQL

SQL - GROUP BY and HAVING

Identify the error in this SQL query:

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

ACOUNT(*) cannot be used with GROUP BY

BGROUP BY should come before WHERE

Cdepartment cannot be selected with GROUP BY

DWHERE clause is missing a condition

Step-by-Step Solution

Solution:

Step 1: Review WHERE clause usage
WHERE requires a condition to filter rows; 'WHERE department' alone is invalid.
Step 2: Confirm correct clause order
GROUP BY must come after WHERE, so order is correct.
Final Answer:
WHERE clause is missing a condition -> Option D
Quick Check:
WHERE needs condition, not just column name [OK]

Quick Trick: WHERE must have a condition, not just a column [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 SQL query: