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

 

SELECT P.PRODUCT_ID,P.PRODUCT_NAME, SUM(O.AMOUNT)*(P.PRICE) AS TOTAL_SALES
FROM FOOD_ORDER AS O JOIN FOOD_PRODUCT AS P
ON O.PRODUCT_ID = P.PRODUCT_ID
WHERE O.PRODUCE_DATE LIKE '2022-05-%'
GROUP BY PRODUCT_ID
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID

PRODUCT_ID로 그룹화해서 SUM(O.AMOUNT)*(P.PRICE) AS TOTAL_SALES