--2 µ¥¶Ë¿ÚÄܺÄ
select 
city_name as city_name,
grid_name as wg_name,
cost_port_nenghao as wg_dd_nh,
cost_port_nenghao_city as bd_dd_nh,
over_cost_city as bd_dwfd,
rn_city as bd_pm,
cost_port_nenghao_prov as qs_dd_nh,
over_cost_prov as qs_fd,
rn_prov as qs_pm,
city_code as city_id,
smonth as month_id
from sqmdb_cost.rpt_baobiao_2_ddk
where smonth='202205'
order by sort_id_city,rn_city