--13、单端口能耗成本（月）
---北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,
'13' as ZB_CODE,
'单端口能耗成本（月）' as ZB_NAME,
'否' as IS_RATIO,
cost_nenghao as QZ_FZ,
port_inuse as QZ_FM,
cost_nenghao/port_inuse/6 as BY_QZ
from sqmdb_cost.rpt_dport_cost_b10
where smonth='202206'