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

• 문제
  
• 정답

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, DATE_FORMAT(R.REVIEW_DATE, '%Y-%m-%d') REVIEW_DATE
FROM MEMBER_PROFILE M JOIN REST_REVIEW R ON M.MEMBER_ID = R.MEMBER_ID
WHERE R.MEMBER_ID = (
    SELECT MEMBER_ID
    FROM REST_REVIEW 
    GROUP BY 1
    ORDER BY COUNT(*) DESC
    LIMIT 1
)
ORDER BY 3, 2

• 결과