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

Employees & Departments

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems