출처

https://school.programmers.co.kr/learn/courses/30/lessons/77487

문제

풀이

WITH PLACE_COUNT AS (
    SELECT HOST_ID, COUNT(*) AS CNT
    FROM PLACES
    GROUP BY HOST_ID
    HAVING CNT >= 2)

SELECT ID, NAME, HOST_ID
FROM PLACES
WHERE HOST_ID IN (SELECT HOST_ID
                  FROM PLACE_COUNT)
ORDER BY ID