with geo as (
  select
    d.DISTRICT_CODE CODE,
    d.DISTRICT_NAME NAME,
    l.LATITUDE LAT,
    l.LONGITUDE LON
  from location_tbl l
  left join district d using(district_code)
)
, geo_1101 as (
  select geo.*, l1.lat l1lat, l1.lon l1lon
  from geo
  cross join (select LAT, LON from geo where code = 1101) l1
  where code <> 1101
)
select CODE, NAME, LAT, LON
from geo_1101
order by sqrt(pow(lat-l1lat, 2) + pow(lon-l1lon, 2)) desc, CODE