| 12345678910111213141516171819 |
- --03、网运成本预算完成进度（集团口径）
- ---北10（顺序：北京 天津 河北 山西 内蒙古 辽宁 吉林 黑龙江 山东 河南）
- select
- smonth as MONTH_ID,
- '北10' as ZB_TYPE,
- sname as PROV_NAME,
- null as CITY_ID,
- null as CITY_NAME,
- null as GRID_ID,
- null as GRID_NAME,
- '3' as ZB_CODE,
- '网运成本预算完成进度（集团口径）' as ZB_NAME,
- '是' as IS_RATIO,
- column1 as QZ_FZ,
- column2 as QZ_FM,
- case when column2=0 then 1 else column1/column2 end as BY_QZ
- from sqmdb_cost.report50002
- where sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
- and smonth='202207'
|
