Departments Above Average Salary

Problem

Write a query that returns each department's name and average employee salary (aliased as average_salary), grouped by department, but only for departments whose average salary is greater than the company-wide average salary across all employees.

Try It

Hint

Solution