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

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT p.PRODUCT_ID, p.PRODUCT_NAME, p.PRICE * o.AMOUNT as "TOTAL_SALES"
from FOOD_PRODUCT p inner join (select PRODUCT_ID, sum(AMOUNT) as "AMOUNT"
                               from FOOD_ORDER
                               where date_format(PRODUCE_DATE, "%Y-%m") = "2022-05"
                               group by PRODUCT_ID) AS o
on p.PRODUCT_ID = o.PRODUCT_ID
order by TOTAL_SALES desc, p.PRODUCT_ID