프로그래머스 - SQL - 주문량이 많은 아이스크림들 조회하기

• 문제설명
  

• 문제
  

• 문제풀이

# MySQL
SELECT FH.FLAVOR

FROM FIRST_HALF AS FH 
JOIN (SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL_ORDER
      FROM JULY
      GROUP BY FLAVOR) AS J
ON FH.FLAVOR = J.FLAVOR

ORDER BY FH.TOTAL_ORDER + J.TOTAL_ORDER DESC
LIMIT 3

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