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

https://school.programmers.co.kr/learn/courses/30/lessons/131117

정답

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