题解 | 了解 2023 年全年所有商品的盈利情况
了解 2023 年全年所有商品的盈利情况
https://www.nowcoder.com/practice/05cbbb8662c14b46a15cbcb8993d9277
select
s.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
left join purchase_prices using(product_id)
where order_date like '2023%'
group by s.product_id
投递hulu等公司7个岗位