Skip to content

570. Managers with at Least 5 Direct Reports 👍

1
2
3
4
5
6
SELECT Manager.name
FROM Employee
INNER JOIN Employee AS Manager
  ON (Employee.managerId = Manager.id)
GROUP BY Manager.id
HAVING COUNT(*) >= 5;