[프로그래머스, 131533] 상품 별 오프라인 매출 구하기 (mysql)

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

프로그래머스

728x90

---

SELECT product_code, sum(sales_amount * price) as sales
FROM offline_sale as os
left join product as p
on os.product_id = p.product_id
GROUP BY product_code
ORDER BY sales desc, product_code