with st as (select latitude as lat, longitude as lon from location_tbl where district_code = 1101)
, s as (select district_code as code, latitude as lat, longitude as lon from location_tbl where district_code != 1101)
select 
s.code as CODE
, d.district_name as NAME
, s.lat as LAT
, s.lon as LON
from s join district d on s.code = d.district_code cross join st
order by pow((s.lat - st.lat), 2) + pow((s.lon - st.lon), 2) desc, CODE