1
2
3
4
5
6
7
select sub.food_type, main.rest_id, main.rest_name, sub.favorites
from rest_info as main
join (SELECT food_type, max(favorites) as favorites
from rest_info
group by food_type) as sub
on main.food_type = sub.food_type and main.favorites = sub.favorites
order by main.food_type desc;