헤비 유저가 소유한 장소

빛하루 2023. 9. 2. 16:50

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