[GROUP BY/LEVEL2] 성분으로 구분한 아이스크림 총 주문량 (MySQL/Oracle)

MySQL/Oracle

SELECT    INGREDIENT_TYPE
        , SUM(TOTAL_ORDER)
FROM FIRST_HALF A, ICECREAM_INFO B
WHERE A.FLAVOR = B.FLAVOR
GROUP BY INGREDIENT_TYPE
ORDER BY SUM(TOTAL_ORDER);