Skip to content
SQLSimplified
mediumemployeesjoingroup-byhaving

Top Paying Department

Problem

Return the department with the highest average salary (its name and avg_salary), using a grouped query limited to one row.

Try It

Loading playground environment...

Hint

Solution

Next Problem