[Programmers - MySQL] 주문량이 많은 아이스크림들 조회하기

SELECT  h.flavor
FROM  first_half  h
JOIN  (SELECT  flavor
	      ,SUM(total_order) AS july_total_orders
       FROM  july
       GROUP BY  flavor) j
ON  h.flavor = j.flavor
ORDER BY  h.total_orders + j.july_total_orders DESC
LIMIT  3

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