1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
WITH CTE AS (
    SELECT FOOD_TYPE, MAX(FAVORITES) AS MAX_FAVORITES
    FROM REST_INFO
    GROUP BY FOOD_TYPE
)

SELECT
    R1.FOOD_TYPE,
    R1.REST_ID,
    R1.REST_NAME,
    R1.FAVORITES
FROM 
    REST_INFO R1,
    CTE R2
WHERE R1.FOOD_TYPE = R2.FOOD_TYPE AND R1.FAVORITES = R2.MAX_FAVORITES
GROUP BY 1 
ORDER BY 1 DESC