[프로그래머스 / SQL 고득점 Kit] 5월 식품들의 총매출 조회하기

📄 문제

 

💡 풀이

<Oracle>

SELECT fp.product_id, product_name, SUM(amount)*price total_sales
FROM food_product fp RIGHT JOIN food_order fo ON fp.product_id = fo.product_id
WHERE TO_CHAR(produce_date,'yyyy-MM') = '2022-05'
GROUP BY fp.product_id, product_name, price
ORDER BY total_sales DESC, fp.product_id