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

문제

 

 

 

정답

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