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