chengben/Scripts/kpi31/12_city.sql

--12、单端口网运成本（月）
---地市
select 
city.smonth as MONTH_ID,
'地市' as ZB_TYPE,
'河北' as PROV_NAME,
dg.city_code*100 as CITY_ID,
city.city_sname as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'12' as ZB_CODE,
'单端口网运成本（月）' as ZB_NAME,
'否' as IS_RATIO,
city.cost_total as QZ_FZ,
city.port_inuse as QZ_FM,
city.cost_total/city.port_inuse/6 as BY_QZ
from sqmdb_cost.rpt_dport_cost_city city
left join
(select distinct city_code,city_sname from sqmdb_cost.dict_grid) dg
on city.city_sname=dg.city_sname
where smonth='202206'
order by dg.city_code