--09、百元资产修理维护费
---北10
select 
t1.smonth as MONTH_ID,
'北10' as ZB_TYPE,
t1.sname as PROV_NAME,
null as CITY_ID,
null as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'9' as ZB_CODE,
'百元资产修理维护费' as ZB_NAME,
'否' as IS_RATIO,
t1.cost_fix as QZ_FZ,
t2.zichan as QZ_FM,
(t1.cost_fix/t2.zichan)*100 as BY_QZ
from
(select smonth,stype,sname,cost_fix from sqmdb_cost.chengben_shengnei where smonth='202206' and stype='北10') t1
join
(select sname,sum(column7+column8)/2 as zichan from sqmdb_cost.report80054 where period_type='M'
and sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
and stype='分省展现' and smonth between '202201' and '202206' group by sname) t2
on t1.sname=t2.sname