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

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

---

https://school.programmers.co.kr/learn/courses/30/lessons/131124