-- 카티션 프로덕트로 연결한 테이블에 WHERE 문을 사용한 쿼리문 SELECT T2.INGREDIENT_TYPE, SUM(T1.TOTAL_ORDER) AS TOTAL_ORDER FROM FIRST_HALF T1, ICECREAM_INFO T2 WHERE T1.FLAVOR = T2.FLAVOR GROUP BY T2.INGREDIENT_TYPE ORDER BY SUM(T1.TOTAL_ORDER) -- JOIN 문과 ON을 사용한 쿼리문 SELECT T2.INGREDIENT_TYPE, SUM(T1.TOTAL_ORDER) AS TOTAL_ORDER FROM FIRST_HALF T1 JOIN ICECREAM_INFO T2 ON T1.FLAVOR = T2.FLAVOR GROUP BY T2.INGREDIENT_T..
