SELECT 
	L1.DISTRICT_CODE AS CODE
	,D.DISTRICT_NAME AS NAME
	,L1.LATITUDE AS LAT
	,L1.LONGITUDE AS LON
FROM LOCATION_TBL L1, LOCATION_TBL L2
INNER JOIN DISTRICT D ON D.DISTRICT_CODE = L1.DISTRICT_CODE
WHERE L1.DISTRICT_CODE <> '1101'
AND L2.DISTRICT_CODE = '1101'
ORDER BY ((L2.LATITUDE - L1.LATITUDE)*(L2.LATITUDE - L1.LATITUDE) + (L2.LONGITUDE - L1.LONGITUDE)*(L2.LONGITUDE - L1.LONGITUDE)) DESC,L1.DISTRICT_CODE