Team Leads with Five Plus Direct Reports

Medium

You are analyzing an organizational directory where each employee may report to one direct manager. The table schema is: Employee(id, name, department, managerId) Column meanings: id: unique employee identifier name: employee display name department: business unit label managerId: id of that employee's direct manager, or NULL for top-level leaders Task: Return the names of managers who have at least 5 direct reports. Important details: Count only direct reports (one hop), not the full hierarchy. Return exactly one column named name. Result order does not matter. If two qualifying managers share the same name, both rows should appear. Supported submission formats: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

Employee:
| id  | name  | department | managerId |
|-----|-------|------------|-----------|
| 101 | John  | A          | NULL      |
| 102 | Dan   | A          | 101       |
| 103 | James | A          | 101       |
| 104 | Amy   | A          | 101       |
| 105 | Anne  | A          | 101       |
| 106 | Ron   | B          | 101       |

Output

[
  {"name":"John"}
]

Explanation

John (id=101) has five direct reports, so John is included.

Example 2

Input

Employee:
| id | name  | department | managerId |
|----|-------|------------|-----------|
| 1  | Maya  | Sales      | NULL      |
| 2  | Riley | Sales      | 1         |
| 3  | Sam   | Sales      | 1         |
| 4  | Nia   | Sales      | 1         |
| 5  | Lee   | Sales      | 1         |

Output

[]

Explanation

Maya has only four direct reports, so no manager meets the >= 5 requirement.

Example 3

Input

Employee:
| id | name   | department | managerId |
|----|--------|------------|-----------|
| 10 | Avery  | Ops        | NULL      |
| 11 | Kai    | Ops        | 10        |
| 12 | Noor   | Ops        | 10        |
| 13 | Jae    | Ops        | 10        |
| 14 | Uma    | Ops        | 10        |
| 15 | Inez   | Ops        | 10        |
| 50 | Ghost  | X          | 9999      |

Output

[
  {"name":"Avery"}
]

Explanation

Avery qualifies with five direct reports. The managerId=9999 row does not create a manager output because no employee has id 9999.

Constraints

1 <= number of rows in Employee <= 100,000
Employee.id is unique
managerId is NULL or an integer
No employee is the manager of themself
name and department are non-empty text values
Count direct reports only (single-level relationship)
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with exactly one column: name

Employee: | id | name | department | managerId | |-----|-------|------------|-----------| | 101 | John | A | NULL | | 102 | Dan | A | 101 | | 103 | James | A | 101 | | 104 | Amy | A | 101 | | 105 | Anne | A | 101 | | 106 | Ron | B | 101 |

Employee: | id | name | department | managerId | |----|-------|------------|-----------| | 1 | Maya | Sales | NULL | | 2 | Riley | Sales | 1 | | 3 | Sam | Sales | 1 | | 4 | Nia | Sales | 1 | | 5 | Lee | Sales | 1 |

Employee: | id | name | department | managerId | |----|--------|------------|-----------| | 10 | Avery | Ops | NULL | | 11 | Kai | Ops | 10 | | 12 | Noor | Ops | 10 | | 13 | Jae | Ops | 10 | | 14 | Uma | Ops | 10 | | 15 | Inez | Ops | 10 | | 50 | Ghost | X | 9999 |