SELECT 
      DISTRICT.DISTRICT_CODE AS CODE
    , DISTRICT.DISTRICT_NAME AS NAME
    , LT1.LATITUDE           AS LAT
    , LT1.LONGITUDE          AS LON
FROM DISTRICT
INNER JOIN LOCATION_TBL AS LT1
   ON LT1.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
LEFT JOIN LOCATION_TBL AS LT2
   ON LT2.DISTRICT_CODE = '1101'
WHERE DISTRICT.DISTRICT_CODE != '1101'
ORDER BY
      POW(POW(LT1.LATITUDE - LT2.LATITUDE, 2) + POW(LT1.LONGITUDE - LT2.LONGITUDE, 2), 0.5) DESC
    , DISTRICT.DISTRICT_CODE ASC