[프로그래머스] SQL 고득점 Kit : 상품 별 오프라인 매출 구하기

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

프로그래머스

 

-- 코드를 입력하세요
SELECT P.PRODUCT_CODE, sum(O.SALES_AMOUNT*P.PRICE) as PRICE
from PRODUCT P join OFFLINE_SALE O on P.PRODUCT_ID = O.PRODUCT_ID
group by P.PRODUCT_CODE
order by PRICE desc, P.PRODUCT_CODE asc