문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/131123 코드1. 서브쿼리 + 조인 사용 SELECT R1.FOOD_TYPE, R1.REST_ID, R1.REST_NAME, R1.FAVORITES FROM REST_INFO R1 JOIN ( SELECT FOOD_TYPE, MAX(FAVORITES) AS FAVORITES FROM REST_INFO GROUP BY FOOD_TYPE ) R2 ON R1.FOOD_TYPE = R2.FOOD_TYPE AND R1.FAVORITES = R2.FAVORITES ORDER BY R1.FOOD_TYPE DESC; 코드2. 윈도우 함수 사용 SELECT FOOD_TYPE, REST_ID, REST..