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