SELECT 
    a.DISTRICT_CODE   AS CODE
    , c.DISTRICT_NAME AS NAME
    , a.LATITUDE      AS LAT
    , a.LONGITUDE     AS LON
FROM
    LOCATION_TBL a
    INNER JOIN DISTRICT c ON
        a.DISTRICT_CODE = c.DISTRICT_CODE
    , 
    (
        SELECT
            LATITUDE
            , LONGITUDE
        FROM
            LOCATION_TBL
        WHERE
            DISTRICT_CODE = '1101'
    ) b
WHERE
    a.DISTRICT_CODE <> '1101'
ORDER BY
    POW(a.LATITUDE - b.LATITUDE, 2) + POW(a.LONGITUDE - b.LONGITUDE, 2) DESC
    , a.DISTRICT_CODE
;