얼거스 개발 일지

---

내 코드

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

🤓