# leetcode\_570

The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.

+------+----------+-----------+----------+ |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 | +------+----------+-----------+----------+ Given the Employee table, write a SQL query that finds out managers with at least 5 direct report. For the above table, your SQL query should return:

+-------+ | Name | +-------+ | John | +-------+ Note: No one would report to himself.

## Solutions

1. **HAVING COUNT**

```sql
# Write your MySQL query statement below
SELECT e1.Name
    FROM Employee e1 LEFT JOIN Employee e2
    ON e1.Id = e2.ManagerId
    GROUP BY e1.Id
    HAVING COUNT(*) >= 5
```

or

```sql
# Write your MySQL query statement below
SELECT e1.Name
    FROM Employee e1
    WHERE e1.Id IN (SELECT ManagerId FROM Employee GROUP BY ManagerId HAVING COUNT(*) >= 5)
```