[Solved] What is wrong with this query?SELECT AVG(Salary), Department FROM Employees GROUP BY Department; — Ans: No error; query is correct | SQL

SQL - Aggregate Functions

What is wrong with this query?

SELECT AVG(Salary), Department FROM Employees GROUP BY Department;

AColumn order in SELECT is incorrect

BAVG() cannot be used with GROUP BY

CDepartment must be inside AVG()

DNo error; query is correct

Step-by-Step Solution

Solution:

Step 1: Review aggregation with GROUP BY
AVG(Salary) calculates average salary per Department grouped correctly.
Step 2: Confirm syntax and logic
SELECT columns and GROUP BY match; query is valid and returns averages per department.
Final Answer:
No error; query is correct -> Option D
Quick Check:
AVG() with GROUP BY is valid [OK]

Quick Trick: AVG() works fine with GROUP BY columns [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with this query?