목록2024/03/04 (1)
짜리몽땅 매거진
![](http://i1.daumcdn.net/thumb/C150x150/?fname=https://blog.kakaocdn.net/dn/cZ1yEe/btsFod7sV20/2C2SXEjwADd2ARczITgrD1/img.png)
문제1. Managers with at Least 5 Direct Reports 출처 : Leetcode - Medium https://leetcode.com/problems/managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50 정답 쿼리 select name from employee where id in (select managerID from employee group by managerID having count(*)>=5) 문제 해설 1. 주요 포인트 1 - where절 서브쿼리 where id in (select managerID from employee group by managerI..
Data/SQL
2024. 3. 4. 15:55