[SQL문제풀기] 상품 별 오프라인 매출 구하기(JOIN)

Q.

풀이

select b.product_code, sum(b.price * a.sales_amount) as sales 
from product as b
join offline_sale as a on b.product_id = a.product_id
group by b.product_code
order by sales desc, b.product_code asc;