WITH T1 AS(
    SELECT
        LATITUDE AS BASE_LATITUDE,
        LONGITUDE AS BASE_LONGITUDE
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = '1101'
),
T2 AS(
    SELECT
        LOCATION_TBL.DISTRICT_CODE AS CODE,
        DISTRICT.DISTRICT_NAME AS NAME,
        LATITUDE AS LAT,
        LONGITUDE AS LON,
        RANK() OVER(
            ORDER BY
                (LATITUDE - BASE_LATITUDE) * (LATITUDE - BASE_LATITUDE) + (LONGITUDE - BASE_LONGITUDE) * (LONGITUDE - BASE_LONGITUDE) DESC
        ) AS RNK
    FROM
        LOCATION_TBL
        LEFT OUTER JOIN
            T1
        INNER JOIN
            DISTRICT ON DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
    WHERE
        LOCATION_TBL.DISTRICT_CODE != '1101'
)
SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM
    T2
ORDER BY
    RNK ASC,
    CODE ASC