[SQL] 헤비 유저가 소유한 장소

SELECT ID, NAME, HOST_ID
FROM PLACES AS P JOIN (SELECT HOST_ID AS HHID, ID AS HID
                            FROM PLACES
                            GROUP BY HOST_ID
                            HAVING COUNT(*) >= 2) AS H
ON P.HOST_ID = H.HHID
ORDER BY ID ASC;

Input code here