[프로그래머스_SQL] 성분으로 구분한 아이스크림 총 주문량

📜문제

---

https://school.programmers.co.kr/learn/courses/30/lessons/133026

📜정답

---

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