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

SQL - GROUP BY and HAVING

What will be the output of this query?

SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

ASyntax error due to missing WHERE clause

BAll departments with their average salaries

CDepartments with average salary greater than 50000

DDepartments with total salary greater than 50000

Step-by-Step Solution

Solution:

Step 1: Understand HAVING clause
HAVING filters groups after aggregation, here filtering departments with average salary > 50000.
Step 2: Analyze output
Only departments meeting the condition appear with their average salary.
Final Answer:
Departments with average salary greater than 50000 -> Option C
Quick Check:
HAVING filters groups by aggregate condition [OK]

Quick Trick: Use HAVING to filter groups after aggregation [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?