with base as (
  select
    latitude as base_la
    , longitude as base_lo
  from
    location_tbl
  where
    district_code = '1101'
)

select
  district_code as CODE
  , district_name as NAME
  , latitude as LAT
  , longitude as LON
from district
inner join location_tbl
  using(district_code)
cross join base
where district_code != '1101'
order by (pow(latitude - base_la, 2) + pow(longitude - base_lo, 2)) desc, district_code