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,
  location_tbl base
on
  d.district_code = l.district_code
where
  l.district_code != '1101'
  and base.district_code = '1101'
order by
  sqrt(power(l.latitude - base.latitude, 2) + power(l.longitude - base.longitude, 2)) desc,
  d.district_code
;