프로그래머스: 5월 식품들의 총매출 조회하기

내 코드

SELECT PRODUCT_ID, PRODUCT_NAME, sum(PRICE * AMOUNT) as TOTAL_SALES
FROM FOOD_PRODUCT p
LEFT JOIN FOOD_ORDER o
    USING (PRODUCT_ID)
    WHERE o.PRODUCE_DATE LIKE '2022-05-%'
GROUP BY PRODUCT_ID
ORDER BY TOTAL_SALES DESC, PRODUCT_ID

🤓