알고리즘/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;