题解 | 了解 2023 年全年所有商品的盈利情况
了解 2023 年全年所有商品的盈利情况
https://www.nowcoder.com/practice/05cbbb8662c14b46a15cbcb8993d9277
select p.product_id, sum((unit_price-purchase_price)*quantity) total_profit, round((avg(unit_price)-purchase_price)/purchase_price*100,2) profit_margin from sales_orders s join purchase_prices p using (product_id) group by p.product_id order by p.product_id
