👩‍💻 문제

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

🙋‍♀️ 답변

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

출력 결과

🤔