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

SELECT a.product_code, sum(a.price * b.sales_amount) SALES
from product a, offline_sale b
where a.product_id = b.product_id
group by 1
order by 2 DESC, 1