programmers SQL : GROUP BY

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

Q

SELECT II.INGREDIENT_TYPE ,  SUM(FH.TOTAL_ORDER)
FROM FIRST_HALF AS FH JOIN ICECREAM_INFO AS II
USING(FLAVOR)
GROUP BY II.INGREDIENT_TYPE