[Solved] What will be the output of this query?SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10; | SQL

SQL - GROUP BY and HAVING

What will be the output of this query?

SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;

ADepartments with more than 10 employees

BAll departments regardless of employee count

CEmployees with department count over 10

DSyntax error due to missing WHERE clause

Step-by-Step Solution

Solution:

Step 1: GROUP BY groups employees by department
Each department forms a group of employees.
Step 2: HAVING filters groups with COUNT(*) > 10
Only departments with more than 10 employees are included in output.
Final Answer:
Departments with more than 10 employees -> Option A
Quick Check:
HAVING filters groups by aggregate count [OK]

Quick Trick: HAVING filters groups by aggregate conditions [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 will be the output of this query?