order (1) 썸네일형 리스트형 [Programmers - MySQL] 주문량이 많은 아이스크림들 조회하기 SELECT h.flavorFROM first_half hJOIN (SELECT flavor ,SUM(total_order) AS july_total_orders FROM july GROUP BY flavor) jON h.flavor = j.flavorORDER BY h.total_orders + j.july_total_orders DESCLIMIT 3https://school.programmers.co.kr/learn/courses/30/lessons/133027 이전 1 다음