--16、单站铁塔租赁费（月）
---北10数据（select * from sqmdb_cost.report50016）
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,
'16' as ZB_CODE,
'单站铁塔租赁费（月）' as ZB_NAME,
'否' as IS_RATIO,
column2*10000 as QZ_FZ,
column5 as QZ_FM,
column2*10000/column5/6 as BY_QZ
from sqmdb_cost.report50016
where sname in ('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
and smonth='202206'