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

문제

코드

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

 

출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/131124