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

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

프로그래머스

 

-- 코드를 입력하세요
SELECT p.PRODUCT_CODE, 
    SUM(p.PRICE * o.SALES_AMOUNT)  as SALES
from Product as p
inner join OFFLINE_SALE as o
on p.PRODUCT_ID = o.PRODUCT_ID
group by p.Product_code
order by SALES desc, p.product_code;

 

상품 매출 계산

SUM(p.PRICE * o.SALES_AMOUNT)

 

마지막에 꼭 상품 '별'로 묶어준다

group by p.product_code