[ORACLE_SQL]주문량이 많은 아이스크림들 조회하기(X)

SELECT C.FLAVOR
FROM
(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
 ) C
WHERE ROWNUM <=3