SELECT
D.DISTRICT_CODE AS CODE,
D.DISTRICT_NAME AS NAME,
T.LATITUDE AS LAT,
T.LONGITUDE AS LON

FROM DISTRICT AS D
 INNER JOIN LOCATION_TBL AS T
  ON D.DISTRICT_CODE = T.DISTRICT_CODE
   AND D.DISTRICT_CODE != '1101'
   
   CROSS JOIN LOCATION_TBL AS LT
    ON LT.DISTRICT_CODE = '1101'
    
ORDER BY
(POW(LT.LATITUDE - T.LATITUDE, 2) + POW(LT.LONGITUDE - T.LONGITUDE, 2)) DESC,
D.DISTRICT_CODE ASC;