WITH base_location AS (
  SELECT LATITUDE as base_lat, LONGITUDE as base_lon
  FROM LOCATION_TBL
  WHERE DISTRICT_CODE = '1101'
),
distances AS (
  SELECT 
    D.DISTRICT_CODE AS CODE, 
    D.DISTRICT_NAME AS NAME, 
    L.LATITUDE AS LAT, 
    L.LONGITUDE AS LON,
    ((base_lat - L.LATITUDE) * (base_lat - L.LATITUDE) + (base_lon - L.LONGITUDE) * (base_lon - L.LONGITUDE)) AS distance_squared
  FROM DISTRICT D
  JOIN LOCATION_TBL L ON D.DISTRICT_CODE = L.DISTRICT_CODE, base_location
  WHERE D.DISTRICT_CODE <> '1101'
)
SELECT CODE, NAME, LAT, LON
FROM distances
ORDER BY distance_squared DESC, CODE ASC;