[JOIN] 그룹별 조건에 맞는 식당 목록 출력하기 (☆☆)

✅ 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/131124
✅ COUNT의 MAX값을 구하는 방법은 서브쿼리로 COUNT DESC 정렬 후 LIMIT 1한 ID가 같은지를 WHERE절 조건으로 작성하면 된다.

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, DATE_FORMAT(R.REVIEW_DATE,"%Y-%m-%d") AS REVIEW_DATE
FROM MEMBER_PROFILE AS M
JOIN REST_REVIEW AS 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(REVIEW_ID) DESC
    LIMIT 1
)
ORDER BY R.REVIEW_DATE, R.REVIEW_TEXT