MySQL - 프로그래머스 코딩테스트 [JOIN - 그룹별 조건에 맞는 식당 목록 출력하기]

SELECT A.MEMBER_NAME, B.REVIEW_TEXT, B.REVIEW_DATE
  FROM MEMBER_PROFILE A INNER JOIN 
       REST_REVIEW B ON A.MEMBER_ID = B.MEMBER_ID
 WHERE A.MEMBER_ID = (
    SELECT MEMBER_ID
      FROM REST_REVIEW
     GROUP BY MEMBER_ID
     ORDER BY COUNT(MEMBER_ID) DESC
     LIMIT 0, 1
    )
 ORDER BY B.REVIEW_DATE;