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....