[Solved] Which of the following SQL queries correctly uses GROUP BY to count employees per department? — Ans: SELECT department, COUNT(*) FROM employees GROUP BY department.; | SQL

SQL - GROUP BY and HAVING

Which of the following SQL queries correctly uses GROUP BY to count employees per department?

ASELECT department, COUNT(*) FROM employees GROUP BY.;

BSELECT department, COUNT(*) FROM employees GROUP BY department.;

CSELECT department, COUNT(*) FROM employees WHERE department GROUP BY.;

DSELECT department, COUNT(*) FROM employees.;

Step-by-Step Solution

Solution:

Step 1: Check the syntax of GROUP BY usage
The correct syntax requires specifying the column after GROUP BY and using aggregate functions properly.
Step 2: Analyze each option
Only SELECT department, COUNT(*) FROM employees GROUP BY department; correctly groups by department and counts employees. The other options have syntax errors: missing column after GROUP BY, no GROUP BY clause, or invalid WHERE syntax.
Final Answer:
SELECT department, COUNT(*) FROM employees GROUP BY department; -> Option B
Quick Check:
GROUP BY column + aggregate function = correct syntax [OK]

Quick Trick: GROUP BY must be followed by column names, aggregate functions used outside [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following SQL queries correctly uses GROUP BY to count employees per department?