[프로그래머스, 131117] 5월 식품들의 총매출 조회하기 (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/131117

프로그래머스

728x90

---

SELECT fp.product_id, fp.product_name, SUM(fo.amount) * fp.price AS total_sales
FROM food_product fp JOIN food_order fo ON fp.product_id = fo.product_id
WHERE fo.produce_date BETWEEN '2022-05-01' AND '2022-05-31'
GROUP BY fp.product_id
ORDER BY total_sales DESC, fp.product_id