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

SELECT D.MEMBER_NAME, A.REVIEW_TEXT, DATE_FORMAT(A.REVIEW_DATE, "%Y-%m-%d")
FROM 
(SELECT A.MEMBER_ID, A.REVIEW_TEXT, A.REVIEW_DATE
FROM REST_REVIEW A
INNER JOIN
(SELECT *
FROM (SELECT MEMBER_ID, RANK() OVER(ORDER BY CNT DESC) RNK
FROM (SELECT MEMBER_ID, COUNT(MEMBER_ID) AS CNT
FROM REST_REVIEW
GROUP BY 1) A) B 
WHERE B.RNK = 1) C ON C.MEMBER_ID = A.MEMBER_ID) A
INNER JOIN MEMBER_PROFILE D ON A.MEMBER_ID = D.MEMBER_ID
ORDER BY 3