SELECT D.DISTRICT_CODE AS CODE, DISTRICT_NAME AS NAME,
L.LATITUDE AS LAT, L.LONGITUDE AS LON
FROM DISTRICT D INNER JOIN LOCATION_TBL L
ON D.DISTRICT_CODE = L.DISTRICT_CODE
CROSS JOIN LOCATION_TBL LT
ON LT.DISTRICT_CODE = '1101'
WHERE CODE <> '1101'
ORDER BY POW(L.LATITUDE - LT.LATITUDE, 2) + POW(L.LONGITUDE - LT.LONGITUDE, 2) DESC,
CODE ASC