[Solved] Identify the error in this SQL query:SELECT department, COUNT(*) FROM employees; — Ans: Missing GROUP BY clause for the department column. | SQL

SQL - GROUP BY and HAVING

Identify the error in this SQL query:

SELECT department, COUNT(*) FROM employees;

AThe query is correct and will run without errors.

BCOUNT(*) cannot be used without WHERE clause.

Cdepartment cannot be selected without aggregation.

DMissing GROUP BY clause for the department column.

Step-by-Step Solution

Solution:

Step 1: Check SELECT with aggregation
COUNT(*) is an aggregate but department is not aggregated or grouped.
Step 2: Identify missing GROUP BY
To select department with COUNT(*), GROUP BY department is required.
Final Answer:
Missing GROUP BY clause for the department column. -> Option D
Quick Check:
Non-aggregated columns need GROUP BY [OK]

Quick Trick: Non-aggregated columns need 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: