[JOIN] 5월 식품들의 총매출 조회하기: 프로그래머스

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

-- 코드를 입력하세요
SELECT A.PRODUCT_ID,B.PRODUCT_NAME, SUM(A.AMOUNT)*B.PRICE AS TOTAL_PRICE
FROM FOOD_ORDER A JOIN FOOD_PRODUCT B
    ON A.PRODUCT_ID = B.PRODUCT_ID
WHERE PRODUCE_DATE LIKE "2022-05-%"
GROUP BY PRODUCT_ID
ORDER BY TOTAL_PRICE DESC, PRODUCT_ID