--05、百元资产网运成本(集团口径)表九 ---北10 select '202206' 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, '5' 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 sname,sum(column1)/10000 as cost_total from sqmdb_cost.report50 where period_type='M' and stype='分省展现' and smonth between '202201' and '202206' group by sname) a left join (select sname,sum(column7+column8)/2 as zichan from sqmdb_cost.report80054 where period_type='M' and stype='分省展现' and smonth between '202201' and '202206' group by sname) b on a.sname=b.sname where a.sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')