chengben/Scripts/kpi31/28_city.sql

--28、单OLT承载活动ONU数
---地市
select 
oo.smonth as MONTH_ID,
'地市' as ZB_TYPE,
'河北' as PROV_NAME,
oo.city_code*100 as CITY_ID,
dg.city_name as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'28' as ZB_CODE,
'单OLT承载活动ONU数' as ZB_NAME,
'否' as IS_RATIO,
null as QZ_FZ,
null as QZ_FM,
olt_active_onu as BY_QZ
from sqmdb_cost.olt_onu oo 
join 
(select distinct city_code,city_name from sqmdb_cost.dict_grid) dg
on oo.city_code=dg.city_code
where oo.smonth='202206'
order by oo.city_code