123456789101112131415 |
- ---ÌúËþµ¥Õ¾×âÁÞ·Ñ-µØÊÐ
- ---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
|