sql문제

570. Managers with at Least 5 Direct Reports

semper.fidelis 2022. 9. 4. 23:44
반응형
SELECT cc.name as name FROM (SELECT count(id) as cnt, managerId FROM Employee GROUP BY managerId having cnt>=5) bb JOIN Employee cc ON cc.id = bb.managerId
반응형