WITH C_LAT AS(
    SELECT
        CAST(LATITUDE AS FLOAT) AS LATITUDE
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = '1101'
)
,C_LON AS(
    SELECT
        CAST(LONGITUDE AS FLOAT) AS 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
    ,SQRT(POWER(CAST(T1.LATITUDE AS FLOAT) - (SELECT LATITUDE FROM C_LAT), 2) + POWER(CAST(T1.LONGITUDE AS FLOAT) - (SELECT LONGITUDE FROM C_LON), 2))
FROM
    LOCATION_TBL T1
LEFT JOIN
    DISTRICT T2
ON T1.DISTRICT_CODE = T2.DISTRICT_CODE
WHERE T1.DISTRICT_CODE != '1101'
ORDER BY
    SQRT(POWER(CAST(T1.LATITUDE AS FLOAT) - (SELECT LATITUDE FROM C_LAT), 2) + POWER(CAST(T1.LONGITUDE AS FLOAT) - (SELECT LONGITUDE FROM C_LON), 2)) DESC
    ,T1.DISTRICT_CODE ASC