with loc_1101 as 
(
  select 
    latitude 
    ,longitude
  from location_tbl
  where district_code = '1101'
)
,distance as 
(
  select 
    district_code
    ,latitude
    ,longitude
    ,pow(latitude - (select latitude from loc_1101),2) + pow(longitude - (select longitude from loc_1101), 2) as distance_from_1101
  from location_tbl
  where district_code <> '1101'
)
select 
  d.district_code as CODE 
  ,d.district_name as NAME 
  ,lt.latitude as LAT 
  ,lt.longitude as LON
from distance as lt
inner join district as d 
  on lt.district_code = d.district_code 
order by distance_from_1101 desc, d.district_code
;