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

https://school.programmers.co.kr/learn/courses/30/lessons/133027?language=oracle

프로그래머스

 

 

-- 코드를 입력하세요
SELECT
FLAVOR
FROM
(
    SELECT
    A.FLAVOR
    ,NVL(A.TOTAL_ORDER,0) + NVL(B.TOTAL_ORDER,0) AS RESULT
    FROM FIRST_HALF A, 
    (
        SELECT
        FLAVOR
        ,SUM(TOTAL_ORDER) AS TOTAL_ORDER
        FROM JULY
        GROUP BY FLAVOR
    )B
    WHERE 1=1
    AND A.FLAVOR = B.FLAVOR(+)
    ORDER BY 2 DESC
) WHERE ROWNUM < 4;