chengben/Scripts/kpi31/13_grid.sql

--13、单端口能耗成本（月）
---网格
select 
smonth as MONTH_ID,
'网格' as ZB_TYPE,
'河北' as PROV_NAME,
city_code*100 as CITY_ID,
city_name as CITY_NAME,
grid_code as GRID_ID,
grid_name as GRID_NAME,
'13' as ZB_CODE,
'单端口能耗成本（月）' as ZB_NAME,
'否' as IS_RATIO,
cost_nenghao as QZ_FZ,
ftth_port_sts_count as QZ_FM,
cost_port_nenghao as BY_QZ
from sqmdb_cost.rpt_dport_cost_grid
where smonth='202206'
order by city_code