[Solved] How can you find the department with the highest average salary using aggregation? — Ans: SELECT Department FROM Employees GROUP BY Department ORDER BY AVG(Salary) DESC... | SQL

SQL - Aggregate Functions

How can you find the department with the highest average salary using aggregation?

ASELECT Department, MAX(AVG(Salary)) FROM Employees GROUP BY Department;

BSELECT Department FROM Employees GROUP BY Department ORDER BY AVG(Salary) DESC LIMIT 1;

CSELECT Department, AVG(Salary) FROM Employees WHERE AVG(Salary) = MAX(AVG(Salary));

DSELECT Department FROM Employees WHERE Salary = MAX(Salary);

Step-by-Step Solution

Solution:

Step 1: Calculate average salary per department
GROUP BY Department with AVG(Salary) computes average salaries.
Step 2: Order results to find highest average
ORDER BY AVG(Salary) DESC sorts from highest to lowest average salary.
Step 3: Limit to top result
LIMIT 1 returns only the department with the highest average salary.
Final Answer:
SELECT Department FROM Employees GROUP BY Department ORDER BY AVG(Salary) DESC LIMIT 1; -> Option B
Quick Check:
Use ORDER BY AVG() DESC with LIMIT 1 to find max average [OK]

Quick Trick: Order by AVG() DESC and limit 1 finds highest average [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

How can you find the department with the highest average salary using aggregation?