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

SELECT A.PRODUCT_ID                 AS PRODUCT_ID
     , MAX(A.PRODUCT_NAME)          AS PRODUCT_NAME
     , SUM(B.AMOUNT) * MAX(A.PRICE) AS TOTAL_SALES
  FROM FOOD_PRODUCT A
 INNER
  JOIN FOOD_ORDER   B
    ON A.PRODUCT_ID = B.PRODUCT_ID
 WHERE TO_CHAR(B.PRODUCE_DATE, 'YYYYMM') = '202205'
 GROUP BY A.PRODUCT_ID
 ORDER BY SUM(B.AMOUNT) * MAX(A.PRICE) DESC, A.PRODUCT_ID