ji-0630 / CodingTest

코딩테스트 연습 기록
0 stars 0 forks source link

헤비 유저가 소유한 장소 #267

Closed ji-0630 closed 1 year ago

ji-0630 commented 1 year ago

문제 설명

image

ji-0630 commented 1 year ago

나의 풀이

SELECT *
from PLACES
where HOST_ID in (select HOST_ID
                    from PLACES
                 group by HOST_ID
                having count(ID) >= 2)
order by ID