-- 코드를 입력하세요 SELECT I.INGREDIENT_TYPE, SUM(F.TOTAL_ORDER) FROM ICECREAM_INFO I , FIRST_HALF F WHERE I.FLAVOR = F.FLAVOR GROUP BY I.INGREDIENT_TYPE ORDER BY F.TOTAL_ORDER ASC;