Who's Earning Above Their Team's Average?

Comp & Benefits at Kestrel Labs opens the annual review cycle next week, and the first pass is a fairness check: on every team, who is already paid more than that team typically pays?

The awkward part is that there is no single figure to measure people against. Engineering pay and Marketing pay are set by two different markets, so one company-wide number would flag most of Engineering and nobody in Marketing — which tells People Ops nothing they can act on. Each person has to be held up against their own team's typical pay, and that typical pay is not stored anywhere. It has to come out of the same ten rows you are reading.

employees — one row per person. salary is the annual figure in whole dollars. department_id is the team the person sits on; manager_id points at another employee's id and is NULL for the people who lead a team.

The table already exists in the database — there is nothing to create or load.

Task: Write a query returning a single column, name, holding every employee whose salary is strictly above the average salary of their own department. Somebody paid exactly their team's average is not above it and does not appear. The only person on a one-person team can never be above their own average, so that team contributes nobody. Hand the names back in alphabetical order.

Example output — shape only, on invented names.