[ORACLE_SQL]5월 식품들의 총매출 조회하기

정답

    SELECT A.PRODUCT_ID, A.PRODUCT_NAME, SUM(A.PRICE*B.AMOUNT) AS TOTAL_SALES
    FROM FOOD_PRODUCT A JOIN FOOD_ORDER B
    ON A.PRODUCT_ID=B.PRODUCT_ID
    WHERE TO_CHAR(B.PRODUCE_DATE, 'YYYY-MM')='2022-05'
    GROUP BY A.PRODUCT_ID, A.PRODUCT_NAME
    ORDER BY SUM(A.PRICE*B.AMOUNT) DESC, A.PRODUCT_ID ASC

• 간단하게 풀어버린 문제 ! 기분좋아좋아