프로그래머스 - 상품 별 오프라인 매출 구하기 (MySQL)

---

select PRODUCT_CODE, SUM(P.PRICE * O.SALES_AMOUNT) AS SALES
from PRODUCT P
join OFFLINE_SALE O on P.PRODUCT_ID = O.PRODUCT_ID
group by P.PRODUCT_CODE
order by SALES desc, P.PRODUCT_CODE asc;