[Solved] Identify the error in this query:SELECT Department, SUM(Salary) FROM Employees; — Ans: Missing GROUP BY clause for Department | SQL

SQL - Aggregate Functions

Identify the error in this query:

SELECT Department, SUM(Salary) FROM Employees;

ASalary column does not exist

BSUM() cannot be used with Salary

CSELECT must include COUNT() with SUM()

DMissing GROUP BY clause for Department

Step-by-Step Solution

Solution:

Step 1: Check aggregation with non-aggregated columns
When selecting Department and SUM(Salary), Department must be grouped.
Step 2: Identify missing GROUP BY
The query lacks GROUP BY Department, causing an error.
Final Answer:
Missing GROUP BY clause for Department -> Option D
Quick Check:
Non-aggregated columns need GROUP BY [OK]

Quick Trick: Use GROUP BY for columns alongside aggregation [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this query: