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

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT p.PRODUCT_CODE, sum(o.SALES_AMOUNT * p.PRICE) as "SALES"
from PRODUCT p inner join OFFLINE_SALE o
on p.PRODUCT_ID = o.PRODUCT_ID
group by p.PRODUCT_CODE
order by SALES desc, p.PRODUCT_CODE