with st as (
select latitude as lat, longitude as lon
from location_tbl
where district_code = '1101'
)
select 
location_tbl.district_code as CODE
, district.district_name as NAME
, latitude as LAT
, LONGITUDE as LON
from location_tbl join district on location_tbl.district_code = district.district_code cross join st
where location_tbl.district_code != '1101'
order by 
abs(location_tbl.latitude - st.lat) * abs(location_tbl.latitude - st.lat) + abs(location_tbl.longitude - st.lon) * abs(location_tbl.longitude - st.lon)
desc, location_tbl.district_code asc