chengben/Scripts/kpi31/26_city.sql

--26、H端口实占率
---地市新版（使用baobiao_ipduankou整理）
select 
month_id as MONTH_ID,
'地市' as ZB_TYPE,
'河北' as PROV_NAME,
city_code*100 as CITY_ID,
city_name as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'26' as ZB_CODE,
'H端口实占率' as ZB_NAME,
'是' as IS_RATIO,
port_inuse as QZ_FZ,
port_total as QZ_FM,
port_rate as BY_QZ
from 
(select month_id,city_name,
port_total,port_inuse,port_rate from sqmdb_cost.jt_number_city jnc where month_id='202206') a
join 
(select distinct city_code,city_sname from sqmdb_cost.dict_grid) dg
on a.city_name=dg.city_sname
order by city_code