WITH BASE AS(
    SELECT *
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = '1101'
)

SELECT DISTRICT.DISTRICT_CODE AS CODE ,DISTRICT_NAME AS NAME,LATITUDE AS  LAT,LONGITUDE AS LON
FROM DISTRICT INNER JOIN  LOCATION_TBL ON DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
WHERE DISTRICT.DISTRICT_CODE NOT IN ('1101')
ORDER BY POW((SELECT LATITUDE FROM BASE)-LATITUDE,2)+POW((SELECT LONGITUDE FROM BASE)-LONGITUDE,2) DESC,DISTRICT.DISTRICT_CODE