[SQL] 그룹별 조건에 맞는 식당 목록 출력하기

반응형

 

 

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

프로그래머스

 

 

정답 쿼리

WITH REVIEW_MAX AS (
    SELECT M.MEMBER_ID, M.MEMBER_NAME, COUNT(*) CNT
    FROM MEMBER_PROFILE M
    JOIN REST_REVIEW R
        ON M.MEMBER_ID = R.MEMBER_ID
    GROUP BY MEMBER_ID
    ORDER BY CNT DESC
    LIMIT 1
)

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, DATE_FORMAT(R.REVIEW_DATE, '%Y-%m-%d') REVIEW_DATE
FROM REST_REVIEW R
JOIN REVIEW_MAX M
    ON R.MEMBER_ID = M.MEMBER_ID
ORDER BY REVIEW_DATE ASC, R.REVIEW_TEXT ASC