SQL 고득점 Kit - JOIN Level4 - 그룹별 조건에 맞는 식당 목록 출력하기 - mysql

https://school.programmers.co.kr/learn/challenges?page=1&languages=mysql&order=recent

select member_name, review_text, date_format(review_date, '%Y-%m-%d') as review_date
from rest_review
inner join (
    select member_id as join1_member_id, count(*) as count
    from rest_review
    group by member_id
    order by count desc
    limit 1
) join1 on rest_review.member_id = join1.join1_member_id
inner join (
    select member_id as join2_member_id, member_name
    from member_profile
) join2 on rest_review.member_id = join2.join2_member_id
order by review_date asc, review_text asc

from <테이블명>

inner join(

) join1 on 테이블명.key = join1.key