[SQL] 성분으로 구분한 아이스크림 총 주문량

 

https://school.programmers.co.kr/learn/courses/30/lessons/133026?language=mysql

프로그래머스

---

SELECT i.INGREDIENT_TYPE, SUM(f.TOTAL_ORDER) as TOTALORDER
FROM FIRST_HALF f 
JOIN ICECREAM_INFO i 
ON f.FLAVOR = i.FLAVOR
GROUP BY i.INGREDIENT_TYPE 
ORDER BY TOTALORDER