Managers with three or more reports
Mediumsqlself joingroup byhaving
In staff, manager_id is the direct manager's id (or NULL). Return the name of every manager with three or more direct reports, sorted by name.
Tables
- staff (id INTEGER, name TEXT, manager_id INTEGER)
Example 1
staff
| id | name | manager_id |
|---|---|---|
| 1 | Mona | NULL |
| 2 | Omar | 1 |
| 3 | Laila | 1 |
| 4 | Hana | 1 |
| 5 | Ziad | 2 |
| 6 | Ali | 2 |
Expected result
| name |
|---|
| Mona |
Constraints
- 0 ≤ rows ≤ 1000
- The order of rows matters
Submit checks your solution against 7 tests, including hidden ones.
SQL
-- Write one SELECT query. Tables: staff SELECT