FunctionRacerProblemsRace

More Than the Manager

MediumSQLSQLite

manager_id is the id of a person's manager, a row of the same table (NULL for people with none). Return the name of everyone who earns more than their own manager. Rows may come in any order.

Example 1

employees
idnamesalarymanager_id
1Ada9000NULL
2Ben95001
3Cy40001
4Dee40003
returns
name
Ben

Constraints

Race itor take your time

Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.

More SQL problems