[Solved] Identify the error in this SQL query:SELECT department, AVG(salary) FROM employees HAVING AVG(salary) > 50000 WHERE department LIKE 'Sales%' GROUP BY department; | SQL

SQL - GROUP BY and HAVING

Identify the error in this SQL query:

SELECT department, AVG(salary) FROM employees HAVING AVG(salary) > 50000 WHERE department LIKE 'Sales%' GROUP BY department;

AWHERE clause used after HAVING

BHAVING clause used before GROUP BY

CMissing alias for AVG(salary)

DGROUP BY clause missing

Step-by-Step Solution

Solution:

Step 1: Check SQL clause order
The correct order is WHERE, then GROUP BY, then HAVING.
Step 2: Identify misplaced WHERE clause
In the query, WHERE appears after HAVING, which is invalid syntax.
Final Answer:
WHERE clause used after HAVING -> Option A
Quick Check:
WHERE before GROUP BY, HAVING after [OK]

Quick Trick: WHERE before GROUP BY, HAVING after GROUP BY [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: