7월 아이스크림 총 주문량과 상반기의 아이스크림 총 주문량을 더한 값이 큰 순서대로 상위 3개의 맛을 조회하는 SQL 문을 작성해주세요.
SELECT A.FLAVOR
FROM FIRST_HALF A
JOIN (SELECT FLAVOR, SUM(TOTAL_ORDER) AS TOTAL_ORDER
FROM JULY
GROUP BY FLAVOR) B
ON A.FLAVOR = B.FLAVOR
ORDER BY (A.TOTAL_ORDER + B.TOTAL_ORDER) DESC
LIMIT 3;
SELECT FLAVOR
FROM (
SELECT FLAVOR
FROM (
SELECT *
FROM FIRST_HALF
UNION ALL
SELECT *
FROM JULY
)
GROUP BY FLAVOR
ORDER BY SUM(TOTAL_ORDER) DESC
)
WHERE ROWNUM <= 3
SELECT A.FLAVOR
FROM (SELECT B.FLAVOR
, SUM(B.TOTAL_ORDER) + SUM(C.TOTAL_ORDER) AS TOTAL
FROM FIRST_HALF B
JOIN JULY C ON B.FLAVOR = C.FLAVOR
GROUP BY B.FLAVOR
ORDER BY TOTAL DESC
) A
WHERE ROWNUM <= 3