Skip to content
SQLSimplified
mediumemployeessubquerycorrelated

Employees Above Dept Average

Problem

Return first_name and salary of employees earning more than their own department's average salary, ordered by salary descending.

Try It

Loading playground environment...

Hint

Solution

Next Problem