select distinct
city_sname as city_name,	--地市分公司
station_sname as jz_name,--局站名称
area_name as county_name,	--区县名称
station_sid as zy_jz_id,	--局站ID
station_type as zy_jz_type,--局站类型
station_level as zy_cj,--所属场景
property_type as zy_qs_type,--权属类别
tower_cost as tt_zj,	--铁塔租金
changd_cost as tt_qz_cz,	--其中：场租
zhejiu_cost as tt_qz_zj,	--其中：折旧
service_property as tt_ywsx,--业务属性
production_type as tt_cplx,	--产品类型
site_addr_id as tt_zz_code,	--铁塔站址编码
tower_cbzx as tt_cb,		--成本中心
changd_cost_grid as wg_wg_j, --场租（网格）
over_changd_cost_grid as wg_czbs,--场租倍数（网格）
tower_cost_grid as wg_wg_zlf,	--租赁费 本网格
over_tower_cost_grid as wg_zlfbs,--租赁费倍数（网格）
changd_cost_city as ds_bdw, --场租（地市） 
over_changd_cost_city as ds_czbs,--场租倍数（地市）
tower_cost_city as ds_bdw_zlf,	--租赁费 本地市
over_tower_cost_city as ds_zlfbs,--租赁费倍数（地市）
changd_cost_grid_scene_good as tt_cz_cj_wg_y,--场租：本场景本网格最优
changd_cost_grid_scene_avg as tt_cz_cj_wg_j,	--场租：本场景本网格均值
changd_cost_grid_scene_bs as tt_cz_czbs,	--场租：场租倍数
changd_cost_city_scene_good as tt_cz_cj_ds_wg_y,--场租：本场景本地市网格内最优
changd_cost_city_scene_avg as tt_cz_cj_ds_wg_j,	--场租：本场景本地市网格内均值
tower_cost_grid_scene_good as tt_zlf_cj_wg_y,	--铁塔租赁费：本场景本网格最优
tower_cost_grid_scene_avg as tt_zlf_cj_wg_j,	--铁塔租赁费：本场景本网格均值
tower_cost_grid_scene_bs as tt_zlf_zlfbs,	--铁塔租赁费：租赁费倍数
tower_cost_city_scene_good as tt_zlf_cj_ds_wg_y,	--铁塔租赁费：本场景本地市网格内最优
tower_cost_city_scene_avg as tt_zlf_cj_ds_wg_j,	--铁塔租赁费：本场景本地市网格内均值
cost_hetong as ht_zj,	--合同租金
hetong_sid as ht_code,		--合同编号
hetong_cbzx as ht_cb,	--合同成本中心
ht_cost_grid_scene_good as thr_wg_y_new,	--本场景本网格最优
ht_cost_city_scene_good as thr_ds_y_new,	--本场景本地市网格内最优
ht_cost_grid_scene_avg as thr_ds_j_new,		--本场景本地市网格内均值
ht_cost_grid_scene_bs as thr_zjbs,		--租金倍数
ht_cost_cbzx_good as thr_dw_y_new,			--本场景本单位最优
city_code as city_id,
smonth as month_id,
grid_code as county_id,
sort_id_city,
station_level_id
from sqmdb_cost.rpt_baobiao_4_cgzf
where smonth='202205'
order by sort_id_city,station_level_id,service_property,production_type,changd_cost desc