Find Department With Highest Average Salary

sql
Copy
SELECT department_name, AVG(salary) AS average_salary
FROM employees
GROUP BY department_name
ORDER BY average_salary DESC
LIMIT 1;

This query calculates the average salary for each department, sorts the results in descending order, and returns the top record representing the department with the highest average salary.