WITH LOLA AS (
  SELECT
    LATITUDE,
    LONGITUDE
  FROM
    LOCATION_TBL
  WHERE
    DISTRICT_CODE = '1101'
)
SELECT
  DISTRICT.DISTRICT_CODE AS CODE,
  DISTRICT_NAME AS NAME,
  LATITUDE AS LAT,
  LONGITUDE AS LON
FROM
  DISTRICT
  INNER JOIN LOCATION_TBL ON DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
WHERE
  DISTRICT.DISTRICT_CODE NOT IN('1101')
ORDER BY
  (
    LATITUDE - (
      SELECT
        LATITUDE
      FROM
        LOLA
    )
  ) * (
    LATITUDE - (
      SELECT
        LATITUDE
      FROM
        LOLA
    )
  ) + (
    LONGITUDE - (
      SELECT
        LONGITUDE
      FROM
        LOLA
    )
  ) * (
    LONGITUDE - (
      SELECT
        LONGITUDE
      FROM
        LOLA
    )
  ) DESC,
  DISTRICT.DISTRICT_CODE