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