[프로그래머스] 그룹별 조건에 맞는 식당 목록 출력하기

문제

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

프로그래머스

 

코드

MySQL

SELECT
    MEMBER_NAME,
    REVIEW_TEXT,
    DATE_FORMAT(REVIEW_DATE, '%Y-%m-%d') AS REVIEW_DATE
FROM
    MEMBER_PROFILE,
    REST_REVIEW
WHERE
    MEMBER_PROFILE.MEMBER_ID = REST_REVIEW.MEMBER_ID
    AND MEMBER_PROFILE.MEMBER_ID = (SELECT
                                     MEMBER_ID
                                 FROM
                                     REST_REVIEW
                                 GROUP BY
                                     MEMBER_ID
                                 ORDER BY
                                     COUNT(*) DESC
                                 LIMIT 1)
ORDER BY
    REVIEW_DATE,
    REVIEW_TEXT