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

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