5월 식품들의 총매출 조회하기1 JOIN>5월 식품들의 총매출 조회하기 SELECT A.PRODUCT_ID, A.PRODUCT_NAME, **SUM**(B.AMOUNT*A.PRICE) AS TOTAL_SALES FROM FOOD_PRODUCT A JOIN FOOD_ORDER B ON A.PRODUCT_ID = B.PRODUCT_ID WHERE B.PRODUCE_DATE LIKE '2022-05-%' **GROUP BY PRODUCT_ID** ORDER BY TOTAL_SALES DESC, PRODUCT_ID 2023. 2. 26. 이전 1 다음 728x90