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
        ,(SUB1.LATITUDE - LOCATION_TBL.LATITUDE) * (SUB1.LATITUDE - LOCATION_TBL.LATITUDE) +
        (SUB1.LONGITUDE - LOCATION_TBL.LONGITUDE) * (SUB1.LONGITUDE - LOCATION_TBL.LONGITUDE) 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