반응형
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반응형
'sql문제' 카테고리의 다른 글
| 610. Triangle Judgement (0) | 2022.09.05 |
|---|---|
| 574. Winning Candidate (0) | 2022.09.05 |
| 550. Game Play Analysis IV (0) | 2022.09.03 |