MySQL - 프로그래머스 코딩테스트 [JOIN - 5월 식품들의 총매출 조회하기]

SELECT A.PRODUCT_ID, A.PRODUCT_NAME, A.PRICE*SUM(B.AMOUNT) AS TOTAL_SALES
  FROM FOOD_PRODUCT A LEFT OUTER JOIN
       FOOD_ORDER B ON A.PRODUCT_ID = B.PRODUCT_ID
 WHERE DATE_FORMAT(B.PRODUCE_DATE, '%Y-%m') = '2022-05'
 GROUP BY A.PRODUCT_ID
 ORDER BY TOTAL_SALES DESC;