WITH SUB1 AS(
    SELECT
        LATITUDE
        ,LONGITUDE
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = '1101'
), DISTANCE_TBL AS(
    SELECT
        DISTRICT_CODE
        ,LOCATION_TBL.LATITUDE
        ,LOCATION_TBL.LONGITUDE
        ,POW(SUB1.LATITUDE - LOCATION_TBL.LATITUDE, 2) + POW(SUB1.LONGITUDE - LOCATION_TBL.LONGITUDE, 2) AS DISTANCE
    FROM
        LOCATION_TBL
            CROSS JOIN SUB1
)
SELECT
    DISTANCE.DISTRICT_CODE AS CODE
    ,DISTRICT.DISTRICT_NAME AS NAME
    ,DISTANCE.LATITUDE AS LAT
    ,DISTANCE.LONGITUDE AS LON
FROM
    DISTANCE_TBL AS DISTANCE
        LEFT OUTER JOIN DISTRICT
            ON DISTANCE.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
WHERE
    DISTANCE.DISTRICT_CODE <> '1101'
ORDER BY
    DISTANCE.DISTANCE DESC
    ,DISTANCE.DISTRICT_CODE ASC