WITH C_LAT AS(
    SELECT
        LATITUDE
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = 1101
)

,C_LON AS(
    SELECT
        LONGITUDE
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = 1101
)

SELECT
    T1.DISTRICT_CODE AS CODE
    ,T2.DISTRICT_NAME AS NAME
    ,T1.LATITUDE AS LAT
    ,T1.LONGITUDE AS LON
FROM
    LOCATION_TBL T1
LEFT JOIN
    DISTRICT T2
ON T1.DISTRICT_CODE = T2.DISTRICT_CODE
WHERE T1.DISTRICT_CODE != 1101
ORDER BY
    SQRT(POWER(T1.LATITUDE - (SELECT LATITUDE FROM C_LAT), 2) + POWER(T1.LONGITUDE - (SELECT LONGITUDE FROM C_LON), 2)) DESC
    ,T1.DISTRICT_CODE