문제설명

문제

답

SELECT memberProfile.MEMBER_NAME,
       restReview.REVIEW_TEXT,
       TO_CHAR(restReview.REVIEW_DATE, 'YYYY-MM-DD') AS REVIEW_DATE
FROM (SELECT MEMBER_ID,   
             RANK() OVER (ORDER BY count(MEMBER_ID) DESC) rank  
      FROM REST_REVIEW 
      GROUP BY MEMBER_ID) reviewCount,
     MEMBER_PROFILE memberProfile,
     REST_REVIEW restReview 
WHERE memberProfile.MEMBER_ID = restReview.MEMBER_ID
AND memberProfile.MEMBER_ID = reviewCount.MEMBER_ID
AND reviewCount.rank = 1
ORDER BY restReview.REVIEW_DATE, restReview.REVIEW_TEXT;