--14、单载频载扇能耗（月）
---北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,
'14' as ZB_CODE,
'单载频载扇能耗（月）' as ZB_NAME,
'否' as IS_RATIO,
cost_yw+cost_hexin as QZ_FZ,
zps_num_no5g as QZ_FM,
case when zps_num_no5g=0 then 0 else (cost_yw+cost_hexin)/zps_num_no5g/6 end as BY_QZ
from sqmdb_cost.rpt_dzpzs_cost_b10 
where smonth='202206'