처음에 실패한거..

SELECT A.INGREDIENT_TYPE, SUM(B.TOTAL_ORDER) AS B.TOTAL_ORDER from ICECREAM_INFO as A
JOIN FIRST_HALF AS B
ON A.FLAVOR = B.FLAVOR
GROUP BY A.INGREDIENT_TYPE
ORDER BY TOTAL_ORDER

맞는거 같은데 뭐가 문제지 했는데 이름을 이렇게 해달라고 했는데 B.TOTAL_ORDER로 써버렸다. 조심하자

성공

SELECT A.INGREDIENT_TYPE, SUM(B.TOTAL_ORDER) AS TOTAL_ORDER from ICECREAM_INFO as A
JOIN FIRST_HALF AS B
ON A.FLAVOR = B.FLAVOR
GROUP BY A.INGREDIENT_TYPE
ORDER BY TOTAL_ORDER