[프로그래머스, 131123] 즐겨찾기가 가장 많은 식당 정보 출력하기 (mysql)

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

프로그래머스

728x90

---

SELECT food_type, rest_id, rest_name, favorites
FROM rest_info
WHERE(food_type, favorites) IN (
    SELECT food_type, MAX(favorites)
    FROM rest_info
    GROUP BY food_type
)
ORDER BY food_type DESC;