[Solved] What is wrong with this query?SELECT department, employee_name, COUNT(*) FROM employees GROUP BY department; | SQL

SQL - GROUP BY and HAVING

What is wrong with this query?

SELECT department, employee_name, COUNT(*) FROM employees GROUP BY department;

AYou cannot select employee_name without grouping by it or using an aggregate function.

BCOUNT(*) cannot be used with GROUP BY.

CGROUP BY must come before SELECT.

DThe query is correct and will run without errors.

Step-by-Step Solution

Solution:

Step 1: Check columns in SELECT with GROUP BY
When using GROUP BY on 'department', all selected columns must be grouped or aggregated.
Step 2: Identify the error
'employee_name' is neither grouped nor aggregated, causing a syntax error.
Final Answer:
You cannot select employee_name without grouping by it or using an aggregate function. -> Option A
Quick Check:
Non-grouped columns must be aggregated [OK]

Quick Trick: All selected columns must be grouped or aggregated [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with this query?