select

lt.DISTRICT_CODE as CODE,
dis.DISTRICT_NAME as NAME,
lt.LATITUDE as LAT,
lt.LONGITUDE as LON

from LOCATION_TBL as lt
join DISTRICT as dis
using(DISTRICT_CODE)

where DISTRICT_CODE != 1101
order by

(POWER((LATITUDE),2) + POWER((LONGITUDE),2)) -
((select POWER((LATITUDE),2) from LOCATION_TBL where DISTRICT_CODE = 1101) +
(select POWER((LONGITUDE),2) from LOCATION_TBL where DISTRICT_CODE = 1101)) desc,1
;