https://school.programmers.co.kr/learn/courses/30/lessons/133026
총주문량 =
SUM
타입별 =GROUP BY
2개의 테이블이므로,WHERE
에서 조인 조건을 걸어주었다.
SELECT I.INGREDIENT_TYPE, SUM(F.TOTAL_ORDER) AS TOTAL_ORDER
FROM FIRST_HALF AS F, ICECREAM_INFO AS I
WHERE F.FLAVOR = I.FLAVOR
GROUP BY I.INGREDIENT_TYPE
ORDER BY F.TOTAL_ORDER