[MySQL] 프로그래머스 - 그룹별 조건에 맞는 식당 목록 출력하기(WHERE문 서브쿼리)

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

프로그래머스

 

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