[프로그래머스 코딩테스트] oracle Lv.3 즐겨찾기가 가장 많은 식당 정보 출력하기

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;