[프로그래머스 Level 4] 그룹별 조건에 맞는 식당 목록 출력하기 (MySQL)

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 rest_review a inner join (
    select member_id, member_name
    from rest_review natural join member_profile
    group by member_id
    order by count(member_id) desc
    limit 1
) b
on a.member_id = b.member_id
order by review_date, review_text