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