Nobody Comes Back
employees:
| id | name | manager_id |
|---|---|---|
| 1 | Ada | NULL |
| 2 | Bob | 1 |
| 3 | Cy | 1 |
| 4 | Dee | 2 |
The intent is "list everyone who manages nobody", so Cy and Dee.
SELECT name
FROM employees
WHERE id NOT IN (SELECT manager_id FROM employees);
What does it actually return?
Sign in to answer questions and track your progress
Sign In