프로그래머스 - 헤비 유저가 소유한 장소

sql 문제

SELECT A.ID, A.NAME, A.HOST_ID FROM PLACES AS A,
(select HOST_ID, ID, COUNT(*) AS CNT from places GROUP BY HOST_ID ORDER BY CNT DESC, ID DESC) AS B
WHERE A.HOST_ID = B.HOST_ID AND B.CNT > 1
ORDER BY A.ID ASC, B.CNT DESC ;

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