Who Reports to No One?
The org-chart tool at Kestrel Labs draws a line from each person up to whoever they report to, and this morning it crashed. The cause turned out to be the people at the top: they report to nobody, so the field holding their manager is empty rather than pointing anywhere, and the tool tried to draw a line to nothing.
Before the fix ships, the engineer wants the list of exactly who those people are, so she can eyeball it against the real leadership team. Alphabetical, because she is reading it against a printed org chart.
employees — one row per person. department_id is the team they sit on, given as the matching id in departments; salary is annual pay in dollars; hire_date is the day they started, written year-month-day; manager_id is the id of the person they report to, and is NULL for anyone who reports to nobody.
| id | name | department_id | salary | hire_date | manager_id |
|---|---|---|---|---|---|
| 1 | Ava Chen | 1 | 145000 | 2021-03-14 | NULL |
| 2 | Ben Ortiz | 1 | 118000 | 2022-06-01 | 1 |
| 3 | Cara Novak | 1 | 121000 | 2023-01-10 | 1 |
| 4 | Deshawn Lee | 2 | 95000 | 2020-09-23 | NULL |
| 5 | Elin Kask | 2 | 88000 | 2022-11-05 | 4 |
| 6 | Farid Amiri | 3 | 76000 | 2023-04-18 | NULL |
| 7 | Grace Kim | 4 | 132000 | 2021-07-30 | NULL |
| 8 | Hugo Silva | 4 | 110000 | 2023-02-14 | 7 |
| 9 | Ines Duarte | 4 | 104000 | 2023-08-01 | 7 |
| 10 | Jonas Weber | 2 | 91000 | 2021-12-19 | 4 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query returning a single column, name, listing every employee who has no manager recorded — that is, whose manager_id is NULL rather than pointing at another employee's id. Sort the rows alphabetically by name, ascending. All four names are different, so that fixes the order exactly.
Example output — shape only, on invented people. If three records had an empty manager slot, you would get:
| name |
|---|
| Mira Solberg |
| Nils Ahlberg |
| Otto Brandt |
Sign in to solve this problem
Reading problems is free for everyone — solving them (Run, Submit, and tracking what you've solved) needs an account.
Sign in