성분별 아이스크림 총 주문량 (JOIN, GROUP BY)

 

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

프로그래머스

난이도 : 레벨2

 

 

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