550. Manager with at least 5 direct reports

[QuXiangjie]

Question

we should use JOIN to combine two tables

SELECT e1.name as name
FROM Employee AS e1
JOIN Employee AS e2 ON e1.id = e2.managerID
group by e1.id
having count(e1.id)>=5