알고리즘/SQL

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

빙빙 2021. 7. 20. 22:13
SELECT *
FROM PLACES 
WHERE HOST_ID IN (
                        SELECT HOST_ID
                        FROM PLACES
                        GROUP BY HOST_ID
                        HAVING COUNT(*) >= 2
                     )
ORDER BY ID;