chengben/Scripts/kpi31/02_b10.sql

--02、网运成本占收比（省内口径）
select 
cs.smonth as MONTH_ID,
'北10' as ZB_TYPE,
cs.sname as PROV_NAME,
null as CITY_ID,
null as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'2' as ZB_CODE,
'网运成本占收比（省内口径）' as ZB_NAME,
'是' as IS_RATIO,
cs.cost_total as QZ_FZ,
r.column4 as QZ_FM,
cs.cost_total/r.column4 as BY_QZ
from sqmdb_cost.chengben_shengnei cs
join sqmdb_cost.report80040 r on cs.smonth=r.smonth and cs.sname=r.sname
where r.period_type='M' 
and cs.stype='北10'
and cs.smonth='202207'