SQL 알고리즘 코드카타 13일차(5) 26.01.11(일)

부제:

성분으로 구분한 아이스크림 총 주문량, 레벨 3

 

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/133026
2. 정답 코드: 

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

3. 오류 상황:
4. 시도 방법:
5. 최종 문제 해결 방법: