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