| 123456789101112131415161718192021222324 |
- --06、百元资产网运成本（省内口径）
- ---北10
- select
- a.smonth as MONTH_ID,
- '北10' as ZB_TYPE,
- a.sname as PROV_NAME,
- null as CITY_ID,
- null as CITY_NAME,
- null as GRID_ID,
- null as GRID_NAME,
- '6' as ZB_CODE,
- '百元资产网运成本（省内口径）' as ZB_NAME,
- '否' as IS_RATIO,
- a.cost_total as QZ_FZ,
- b.zichan as QZ_FM,
- a.cost_total/b.zichan*100 as BY_QZ
- from
- (select smonth,stype,sname,cost_total as cost_total from sqmdb_cost.chengben_shengnei
- where stype='北10' and smonth='202206') a
- join
- (select sname,stype,sum(column7+column8)/2 as zichan from sqmdb_cost.report80054
- where sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
- and stype='分省展现' and period_type='M' and smonth between '202201' and '202206' group by sname,stype) b
- on a.sname=b.sname
|
