
[MySQL] SQL 문제: 즐겨찾기가 가장 많은 식당 정보 출력하기 (IN 활용)
2022. 12. 10. 20:06
DB/SQL Study
문제 문제 링크: https://school.programmers.co.kr/learn/courses/30/lessons/131123 답안코드 더보기 SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITES FROM REST_INFO WHERE (FOOD_TYPE, FAVORITES) IN ( SELECT FOOD_TYPE, MAX(FAVORITES) AS FAVORITES FROM REST_INFO GROUP BY FOOD_TYPE ) ORDER BY FOOD_TYPE DESC 시행착오 SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITES FROM REST_INFO GROUP BY FOOD_TYPE ORDER BY FAVORITES DESC ..