WITH LT1101 AS (
SELECT LATITUDE, LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'
)
SELECT
 LT.DISTRICT_CODE AS CODE
,D.DISTRICT_NAME AS NAME
,LT.LATITUDE AS LAT
,LT.LONGITUDE AS LON
FROM LOCATION_TBL AS LT
     INNER JOIN DISTRICT AS D
     ON LT.DISTRICT_CODE = D.DISTRICT_CODE
     ,LT1101
WHERE LT.DISTRICT_CODE <> '1101'
ORDER BY SQRT((LT.LATITUDE - LT1101.LATITUDE)*(LT.LATITUDE - LT1101.LATITUDE) +  (LT.LONGITUDE - LT1101.LONGITUDE)*(LT.LONGITUDE - LT1101.LONGITUDE)) DESC, LT.DISTRICT_CODE