SELECT I.FOOD_TYPE, I.REST_ID, I.REST_NAME, I.FAVORITES
FROM (
SELECT FOOD_TYPE, MAX(FAVORITES) AS FAVORITES
FROM REST_INFO
GROUP BY FOOD_TYPE
) S LEFT JOIN REST_INFO I
ON S.FOOD_TYPE= I.FOOD_TYPE AND S.FAVORITES = I.FAVORITES
ORDER BY FOOD_TYPE DESC;