출처

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

문제

풀이

SELECT FH.FLAVOR
FROM FIRST_HALF FH
    JOIN (
        SELECT FLAVOR, SUM(TOTAL_ORDER) AS JULY_TOTAL_ORDER
        FROM JULY
        GROUP BY FLAVOR
        ) J
    ON FH.FLAVOR = J.FLAVOR
ORDER BY FH.TOTAL_ORDER + J.JULY_TOTAL_ORDER DESC
LIMIT 3