성분으로 구분한 아이스크림 총 주문량 mysql

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

SELECT I.INGREDIENT_TYPE, SUM(H.TOTAL_ORDER) as TOTAL_ORDER
FROM FIRST_HALF AS H
JOIN ICECREAM_INFO AS I ON H.FLAVOR = I.FLAVOR
GROUP BY I.INGREDIENT_TYPE
ORDER BY TOTAL_ORDER

1. JOIN ON
2. GROUP BY
3. SELECT + SUM