[프로그래머스] 상품 별 오프라인 매출 구하기 SELECT T1.PRODUCT_CODE, SUM(T1.PRICE*T2.SALES_AMOUNT) AS SALES FROM PRODUCT T1 JOIN OFFLINE_SALE T2 ON T1.PRODUCT_ID = T2.PRODUCT_ID GROUP BY T1.PRODUCT_CODE ORDER BY 2 DESC, 1 SQL 2023.07.17
