1
2
3
4
5
6
7
-- 코드를 입력하세요
SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITES
FROM
    (SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITES, MAX(FAVORITES) OVER(PARTITION BY FOOD_TYPE) AS FAV
    FROM REST_INFO)
WHERE FAVORITES = FAV
ORDER BY FOOD_TYPE DESC;