chengben/Scripts/bigscreen/chengben_other_4_city.sql

---ÌúËþµ¥Õ¾×âÁÞ·Ñ-µØÊÐ
---chengben_other_4_city_202203.csv
select 
c.smonth,
c.city_name,
c.tower_cost as tower_cost_total,
c.tower_num_avg as tower_num,
c.tower_cost_avg as tower_cost_avg_city,
dg.city_code*100 as city_code
from sqmdb_cost.rpt_tower_cost_city c
join
(select distinct city_code,city_sname from sqmdb_cost.dict_grid) dg
on c.city_name=dg.city_sname
where smonth='202204'
order by dg.city_code