[프로그래머스] 상품 별 오프라인 매출 구하기 (Oracle)

문제

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

프로그래머스

 

SELECT PRODUCT_CODE,
    SUM(SALES_AMOUNT * PRICE) AS SALES
FROM PRODUCT P, OFFLINE_SALE OS
WHERE P.PRODUCT_ID = OS.PRODUCT_ID
GROUP BY PRODUCT_CODE
ORDER BY SALES DESC, PRODUCT_CODE
;