JOIN>주문량이 많은 아이스크림들 조회하기

-- 직접 짠 코드.
SELECT C.FLAVOR FROM
    (
    SELECT A.SHIPMENT_ID, A.FLAVOR, SUM(A.TOTAL_ORDER + B.TOTAL_ORDER) AS TOTAL
    FROM FIRST_HALF A
    JOIN JULY B ON A.FLAVOR = B.FLAVOR
    GROUP BY FLAVOR
    ORDER BY TOTAL DESC
    ) AS C
ORDER BY C.TOTAL DESC
LIMIT 3

-- GPT로부터  첨삭받음.
SELECT C.FLAVOR FROM
    (
    SELECT A.FLAVOR, SUM(A.TOTAL_ORDER + B.TOTAL_ORDER) AS TOTAL
    FROM FIRST_HALF A
    JOIN JULY B ON A.FLAVOR = B.FLAVOR
    GROUP BY FLAVOR
    ) AS C
ORDER BY C.TOTAL DESC
LIMIT 3

-- 인터넷에서 찾은 방법. 
SELECT A.FLAVOR
FROM FIRST_HALF A
JOIN  
    (
    SELECT FLAVOR, SUM(TOTAL_ORDER) AS  TOTAL_ORDER
    FROM JULY
    GROUP BY FLAVOR
    ) AS B
ON A.FLAVOR = B.FLAVOR
ORDER BY A.TOTAL_ORDER + B.TOTAL_ORDER DESC
LIMIT 3