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.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| 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.
| name | department | salary |
|---|---|---|
| Carol | Engineering | 150000 |
| Eve | Marketing | 90000 |