with t1_1101 as(
select LATITUDE as x, LONGITUDE as y
from LOCATION_TBL
where DISTRICT_CODE = '1101'
), 
t2 as(
select
DISTRICT_CODE as CODE,
LATITUDE as LAT,
LONGITUDE as LON
,sqrt(pow(LATITUDE - x, 2) + pow(LONGITUDE - y, 2)) as dist
from LOCATION_TBL, t1_1101
where DISTRICT_CODE <> '1101'
)
select
    t2.CODE,
    D.DISTRICT_NAME as NAME,
    t2.LAT,
    t2.LON
from t2
inner join DISTRICT D
on D.DISTRICT_CODE = t2.CODE
order by t2.dist desc, 1