WITH
    tmp AS (
        SELECT
            T1.DISTRICT_CODE AS CODE
          , D.DISTRICT_NAME AS NAME
          , T1.LATITUDE AS LAT
          , T1.LONGITUDE AS LON
          , (T1.LATITUDE * 100 - T2.LATITUDE * 100) * (T1.LATITUDE * 100 - T2.LATITUDE * 100) + (T1.LONGITUDE * 100 - T2.LONGITUDE * 100) * (T1.LONGITUDE * 100 - T2.LONGITUDE * 100) 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
    --   , DISTANCE
FROM
    tmp
ORDER BY
    DISTANCE DESC
  , CODE ASC;