HUIHAO12138(提问者)select
(FMaoLv-FXiaoFei)/FXiaoFei as FTuiGbi,FInfoCount,FMaoLv,FChengDanCount/FInfoCount*100,FXiaoFei into @a,@b,@c,@d,@e
from (
#查询信息 销售订单数量 毛利#
select 0 as jdy_org_number, sum(c.gross_profit) as FMaoLv,count(distinct a.id) as FInfoCount,sum(case when `status`=\'销售已成单\' then 1 else 0 end) as FChengDanCount
from db_requirement a
inner join db_jdy_org b on a.sale_org_id=b.depart_id
left join db_requirement_sale_order c on a.id=c.requirement_id
where `sale_org_id` != 0 and `status` <> \'已删除\' and `status` <> \'\' and Year(a.created_at)=2023 and Month(a.created_at) between 2 and 2
and b.jdy_org_id in (100021)) a
left join (
#查询组织消费记录#
select 0 as jdy_org_number,sum(consume_money) as FXiaoFei from db_consume a
left join db_promotion_regist b on a.promote_id=b.id
inner join db_jdy_org c on b.jdy_org_number=c.jdy_org_number
where 1=1 and Year(a.consume_time)=2023 and Month(a.consume_time) = 2
and jdy_org_id in (100021)) b on a.jdy_org_number=b.jdy_org_number
select \'投入产出比\' AS FtypeName,@a as FValue
union all
select \'信息量\' AS FtypeName,@b as FValue
1min目标场景问卷
立即参与
