SQL문제풀이(11)

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

문풀

서브 쿼리를 너무 안써버릇하려고 노력하는 것 같다. 쓸땐 써야..

SELECT
    m.member_name,
    r.review_text,
    DATE_FORMAT(r.review_date, '%Y-%m-%d')
FROM
    member_profile m
INNER 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(member_id) DESC
        LIMIT
            1
    ) 
ORDER BY
    r.review_date ASC, 
    r.review_text ASC;

제일 중요한 부분은
ORDER BY
count(member_id) DESC
하고
LIMIT
1

하는거?!