Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

SQL practice › Subqueries

Above Their Department Average

Medium · Subqueries

Return the name and salary of employees who earn more than the average salary of their own department.

Hint

A correlated subquery computes the average for each employee's department.

Write your query on this page — it runs against the sample company database in your browser and is checked instantly.

Next problem: Best-Selling Product