Employees Earning Above Department Average - Medium SQL Subqueries Interview Problem

Problem

Not all above-average earners are in the same department — you need to compare each employee against their own team's average. Using the employees table, find everyone whose salary is strictly above their department's average.

Return name, department, and salary, ordered by department then name.

Schema

employees

column	type
id	INTEGER
name	TEXT
department	TEXT
salary	INTEGER

Sample Data

id	name	department	salary
1	Alice	Engineering	90000
2	Bob	Engineering	120000
3	Carol	Engineering	150000
4	Dave	Marketing	70000
5	Eve	Marketing	90000

Engineering average = 120,000 → Carol qualifies. Marketing average = 80,000 → Eve qualifies.

Expected Output

name	department	salary
Carol	Engineering	150000
Eve	Marketing	90000

Hints