[SQL] 상품 별 오프라인 매출 구하기

프로그래머스

 

SELECT PRODUCT_CODE, SUM(PRICE * SALES_AMOUNT) AS SALES
FROM OFFLINE_SALE off INNER JOIN PRODUCT pro ON off.PRODUCT_ID = pro.PRODUCT_ID
GROUP BY off.PRODUCT_ID
ORDER BY SUM(PRICE * SALES_AMOUNT) DESC, pro.PRODUCT_CODE;