570-managers-with-at-least-5-direct-reports

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

SELECT name
FROM Employee
JOIN (
    SELECT managerId, count(managerId) as cnt
    From Employee
    GROUP BY managerId
) as b ON Employee.id = b.managerId
WHERE b.cnt >= 5