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

 

정답

SELECT T1.PRODUCT_ID, T1.PRODUCT_NAME, T1.TOTAL_SALES

FROM ( 
       SELECT A.CATEGORY, A.PRODUCT_ID, A.PRODUCT_NAME, SUM(A.PRICE * B.AMOUNT) AS TOTAL_SALES
        FROM FOOD_PRODUCT A
        INNER JOIN FOOD_ORDER B
        ON  A.PRODUCT_ID =B.PRODUCT_ID
        WHERE TO_CHAR(PRODUCE_DATE, 'YYYY-MM') = '2022-05'
        GROUP BY A.CATEGORY, A.PRODUCT_ID, A.PRODUCT_NAME
) T1

ORDER BY T1.TOTAL_SALES DESC, T1.PRODUCT_ID