chengben/Scripts/kpi31/16_city.sql

--16、单站铁塔租赁费（月）
---地市
select 
c.smonth as MONTH_ID,
'地市' as ZB_TYPE,
'河北' as PROV_NAME,
dg.city_code*100 as CITY_ID,
c.city_name as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'16' as ZB_CODE,
'单站铁塔租赁费（月）' as ZB_NAME,
'否' as IS_RATIO,
c.tower_cost as QZ_FZ,
c.tower_num_avg as QZ_FM,
(c.tower_cost/c.tower_num_avg)/6 as BY_QZ
from sqmdb_cost.rpt_tower_cost_city c
left join
(select distinct city_code,city_sname from sqmdb_cost.dict_grid) dg
on c.city_name=dg.city_sname
where smonth='202206'
order by dg.city_code