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

https://school.programmers.co.kr/learn/courses/30/lessons/131117

• 문제 풀이

SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(P.PRICE * O.AMOUNT) AS "TOTAL_SALES"
FROM FOOD_PRODUCT P
JOIN FOOD_ORDER O
ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE TO_CHAR(O.PRODUCE_DATE, 'YYYY-MM') = '2022-05'
GROUP BY P.PRODUCT_ID, P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID;

SELECT 
    P.PRODUCT_ID, 
    P.PRODUCT_NAME, 
    SUM(P.PRICE * O.AMOUNT) AS "TOTAL_SALES"
FROM 
    FOOD_PRODUCT P, FOOD_ORDER O
WHERE 
    P.PRODUCT_ID = O.PRODUCT_ID
    AND TO_CHAR(O.PRODUCE_DATE, 'YYYY-MM') = '2022-05'
GROUP BY 
    P.PRODUCT_ID, 
    P.PRODUCT_NAME
ORDER BY 
    TOTAL_SALES DESC, 
    P.PRODUCT_ID;

• 실행 결과