Team Leads with Five Plus Direct Reports

MEDIUM20 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employee =

[{"id":101,"name":"John","department":"A","managerId":null},{"id":102,"name":"Dan","department":"A","managerId":101},{"id":103,"name":"James","department":"A","managerId":101},{"id":104,"name":"Amy","department":"A","managerId":101},{"id":105,"name":"Anne","department":"A","managerId":101},{"id":106,"name":"Ron","department":"B","managerId":101}]

Team Leads with Five Plus Direct Reports

Hints

Team Leads with Five Plus Direct Reports

Hints