[프로그래머스] 즐겨찾기가 가장 많은 식당 정보 출력하기

문제

제출

제출 1

SELECT food_type,rest_id,rest_name,favorites
from rest_info
where (food_type,favorites) in (select food_type,max(favorites)
                               from rest_info
                               group by food_type)
order by food_type desc

제출 2

SELECT ri.food_type,ri.rest_id,ri.rest_name,ri.favorites
from rest_info as ri
join (select food_type,max(favorites) as mf
     from rest_info
     group by food_type) as a
on a.food_type=ri.food_type and a.mf=ri.favorites
order by food_type desc

식품분류별 가장 비싼 식품의 정보 조회하기와 비슷한 문제