[SQL]프로그래머스 Lv.4 5월 식품들의 총매출 조회하기

✅ 코드

SELECT P.PRODUCT_ID AS PRODUCT_ID
    , P.PRODUCT_NAME AS PRODUCT_NAME
    , SUM(P.PRICE * O.AMOUNT) AS SALES
FROM FOOD_PRODUCT AS P
   INNER JOIN FOOD_ORDER AS O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE O.PRODUCE_DATE BETWEEN '2022-05-01 00:00:00' AND '2022-05-31 23:59:59'
GROUP BY PRODUCT_ID
ORDER BY SALES DESC
      , PRODUCT_ID

INNER JOIN → 5월 생산 식품목록 필터링(WHERE) → GROUP BY 순으로 풀이가 가능합니다.