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

SQL - GROUP BY and HAVING

What will be the result of this query?

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

AList of departments without salary info

BAverage salary for each department

CAverage salary for all employees combined

DSyntax error due to missing WHERE clause

Step-by-Step Solution

Solution:

Step 1: Analyze GROUP BY with AVG()
The query groups employees by department and calculates average salary per group.
Step 2: Understand output meaning
Each row shows a department and its average salary.
Final Answer:
Average salary for each department -> Option B
Quick Check:
GROUP BY department + AVG = average per department [OK]

Quick Trick: AVG with GROUP BY calculates per group average [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 result of this query?