본문 바로가기

algorithm

[programmers] MySQL - Lv.3 헤비 유저가 소유한 장소

문제

 

 

 

 

 

풀이

 

SELECT * from places
where host_id in(select host_id 
                 from places
                 group by host_id 
                 having count(host_id) > 1)
order by id