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