[Solved] What will be the output of this query on table employees with columns department and salary? SELECT department, AVG(salary) FROM employees GROUP BY department; | SQL

SQL - GROUP BY and HAVING

What will be the output of this query on table employees with columns department and salary?

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

AAverage salary for each department

BTotal salary for all employees

CList of employees sorted by salary

DCount of employees in each department

Step-by-Step Solution

Solution:

Step 1: Analyze the query
The query groups employees by department and calculates average salary per group.
Step 2: Determine output meaning
AVG(salary) returns the average salary for each department group.
Final Answer:
Average salary for each department -> Option A
Quick Check:
AVG with GROUP BY = average per group [OK]

Quick Trick: AVG with GROUP BY calculates group averages [OK]

Common Mistakes:

MISTAKES

Confusing average with total
Thinking it lists employees
Assuming it counts employees

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

What will be the output of this query on table employees with columns department and salary?

Step 1: Analyze the query

Step 2: Determine output meaning

Final Answer:

Quick Check:

Want More Practice?