select name,city_name from(select name,city_name,row_number ( ) over(partition by name order by last_order_time desc)as row) where row=1 order by name