select
    d.district_code CODE
    , d.district_name NAME
    , t.latitude LAT
    , t.longitude LON
from DISTRICT d
inner join LOCATION_TBL t on d.district_code=t.district_code
                          and d.district_code != '1101'
cross join LOCATION_TBL lt on lt.district_code='1101'
order by (pow(lt.latitude - t.latitude, 2) + pow(lt.longitude - t.longitude, 2)) desc
         , d.district_code
;