SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM (
    SELECT
        DISTRICT_CODE AS CODE,
        DISTRICT_NAME AS NAME,
        LATITUDE AS LAT,
        LONGITUDE AS LON,
        SQRT(POW((LATITUDE - LAT_1101), 2) + POW((LONGITUDE - LON_1101), 2)) AS DISTANCE
    FROM
        LOCATION_TBL
    INNER JOIN
        DISTRICT USING (DISTRICT_CODE)
    LEFT OUTER JOIN (
        SELECT
            LATITUDE AS LAT_1101,
            LONGITUDE AS LON_1101
        FROM
            LOCATION_TBL
        WHERE
            DISTRICT_CODE = '1101'
    )
    WHERE
        DISTRICT_CODE <> '1101'
)
ORDER BY
    DISTANCE DESC,
    CODE
;