[Solved] Identify the error in this SQL query:SELECT department, AVG(salary) FROM employees ORDER BY AVG(salary) DESC GROUP BY department; | SQL

SQL - GROUP BY and HAVING

Identify the error in this SQL query:

SELECT department, AVG(salary) FROM employees ORDER BY AVG(salary) DESC GROUP BY department;

AAVG(salary) cannot be used in ORDER BY

BORDER BY clause appears before GROUP BY, causing syntax error

CGROUP BY must include salary column

DMissing alias for AVG(salary)

Step-by-Step Solution

Solution:

Step 1: Check clause order
GROUP BY must come before ORDER BY in SQL syntax.
Step 2: Identify error
ORDER BY appears before GROUP BY, which is invalid and causes syntax error.
Final Answer:
ORDER BY clause appears before GROUP BY, causing syntax error -> Option B
Quick Check:
GROUP BY before ORDER BY required [OK]

Quick Trick: GROUP BY must come before ORDER 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: