# 코딩 문제 관련/SQL

[프로그래머스] 헤비 유저가 보유한 장소

Hwiyong Jo 2022. 6. 18. 22:37


SELECT *
    FROM PLACES
    WHERE HOST_ID IN (SELECT DISTINCT HOST_ID
                        FROM PLACES
                        GROUP BY HOST_ID
                        HAVING COUNT(HOST_ID) >= 2)
                        
    ORDER BY ID