[Programmers] 성분으로 구분한 아이스크림 총 주문량

▶MySQL

SELECT II.INGREDIENT_TYPE
      ,SUM(FH.TOTAL_ORDER) AS TOTAL_ORDER
FROM FIRST_HALF FH JOIN ICECREAM_INFO II ON FH.FLAVOR = II.FLAVOR
GROUP BY II.INGREDIENT_TYPE
ORDER BY TOTAL_ORDER ASC;

▶Oracle

SELECT II.INGREDIENT_TYPE
      ,SUM(FH.TOTAL_ORDER) AS TOTAL_ORDER
FROM FIRST_HALF FH
     ,ICECREAM_INFO II 
WHERE FH.FLAVOR = II.FLAVOR
GROUP BY II.INGREDIENT_TYPE
ORDER BY TOTAL_ORDER ASC;