WITH
    tmp AS (
        SELECT
            T1.DISTRICT_CODE AS CODE
          , D.DISTRICT_NAME AS NAME
          , T1.LATITUDE AS LAT
          , T1.LONGITUDE AS LON
          , (T1.LATITUDE - T2.LATITUDE) * (T1.LATITUDE - T2.LATITUDE) + (T1.LONGITUDE - T2.LONGITUDE) * (T1.LONGITUDE - T2.LONGITUDE) AS DISTANCE
        FROM
            LOCATION_TBL T1
            CROSS JOIN LOCATION_TBL T2
            LEFT JOIN DISTRICT D ON D.DISTRICT_CODE = T1.DISTRICT_CODE
        WHERE
            T1.DISTRICT_CODE != '1101'
            AND T2.DISTRICT_CODE = '1101'
    )
SELECT
    CODE
  , NAME
  , LAT
  , LON
FROM
    tmp
ORDER BY
    DISTANCE DESC
  , CODE ASC;