[GROUP BY,SUB QUERY] 즐겨찾기가 가장 많은 식당 정보 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/131123

프로그래머스

 

SELECT A.FOOD_TYPE, A.REST_ID, A.REST_NAME, A.FAVORITES
FROM REST_INFO AS A
WHERE A.REST_ID = (SELECT B.REST_ID FROM REST_INFO AS B WHERE B.FOOD_TYPE = A.FOOD_TYPE ORDER BY B.FAVORITES DESC LIMIT 1)
ORDER BY A.FOOD_TYPE DESC;