chengben/Scripts/report/报表_3_单站租费.sql

--3 µ¥Õ¾×âÁÞ·Ñ
select 
city_name as city_name,
grid_name as wg_name,
tower_cost_avg_area as wg_tt_zlf,
tower_cost_avg_city as bd_tt_zlf,
tower_over_cost_city as bd_dwfd,
tower_rn_city as bd_pm,
tower_cost_avg_prov as qs_zlf,
tower_over_cost_prov as qs_fd,
tower_rn_prov as qs_pm,
ht_avg_cost_grid as thr_wg_zlf,
ht_avg_cost_city as thr_bd_zlf,
ht_over_cost_city as thr_bd_dwfd,
ht_rn_city as thr_bd_pm,
ht_avg_cost_prov as thr_qs_zlf,
ht_over_cost_prov as thr_qs_fd,
ht_rn_prov as thr_qs_pm,
city_code as city_id,
smonth as month_id
from sqmdb_cost.rpt_baobiao_3_dzzl
where smonth='202205'
order by sort_id_city,tower_rn_city