select
  d.district_code as CODE,
  d.district_name as NAME,
  l.latitude as LAT,
  l.longitude as LON
from
  district d
join
  location_tbl l
on
  d.district_code = l.district_code
where
  l.district_code != '1101'
order by
  (select
    sqrt(power(l.latitude - base.latitude, 2) + power(l.longitude - base.longitude, 2))
  from
    location_tbl base
  where
    base.district_code = '1101') desc,
  d.district_code
;