Skip to content
SQLSimplified
hardemployeesjoingroup-byhavingwindow

Departments Above Company Average

Problem

Return departments whose average salary exceeds the company-wide average, with department name and avg_salary, ordered by avg_salary descending.

Try It

Employees & Departments

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems