题解 | #某店铺的各商品毛利率及店铺整体毛利率#

select
ifnull(d.product_id,'店铺汇总') product_id
,concat(round((1-sum(in_price*cnt)/sum(price*cnt))*100,1),'%') profit_rate
from tb_order_detail d join tb_order_overall o using(order_id)
join tb_product_info i using(product_id)
where date_format(event_time,'%Y%m')>=202110
and shop_id=901
group by d.product_id
with rollup
having profit_rate>24.9 or product_id IS NULL
order by product_id