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

---

---

-- 코드를 입력하세요
SELECT A.PRODUCT_ID, A.PRODUCT_NAME , SUM(A.PRICE * B.AMOUNT) AS TOTAL_SALES
FROM FOOD_PRODUCT AS A
LEFT JOIN FOOD_ORDER AS B
ON A.PRODUCT_ID = B.PRODUCT_ID
WHERE YEAR(B.PRODUCE_DATE) = 2022 AND MONTH(B.PRODUCE_DATE) = 5
GROUP BY PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, A.PRODUCT_ID