--14、单载频载扇能耗（月）
---地市
select 
smonth as MONTH_ID,
'地市' as ZB_TYPE,
'河北' as PROV_NAME,
city_code as CITY_ID,
city_sname as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'14' as ZB_CODE,
'单载频载扇能耗（月）' as ZB_NAME,
'否' as IS_RATIO,
cost_yw+cost_hexin as QZ_FZ,
zps_num_with5g as QZ_FM,
case when zps_num_with5g=0 then 0 else (cost_yw+cost_hexin)/zps_num_with5g/6 end as BY_QZ
from sqmdb_cost.rpt_dzpzs_cost_city 
where smonth='202206'
order by city_code