with t as (
select LATITUDE,LONGITUDE from LOCATION_TBL where DISTRICT_CODE = '1101'
),tmp as(
select
    l.DISTRICT_CODE as CODE
    ,d.DISTRICT_NAME as NAME
    ,l.LATITUDE as LAT
    ,l.LONGITUDE as LON
    ,cast(POW(abs(cast(l.LATITUDE as double) - cast((select LATITUDE from t) as double)),2) + POW(abs(cast(l.LONGITUDE as double) - cast((select LONGITUDE from t) as double)),2) as double) as rn
    
from LOCATION_TBL as l
left join DISTRICT as d
on l.DISTRICT_CODE = d.DISTRICT_CODE
where l.DISTRICT_CODE != '1101'
)

select 
    code
    ,name
    ,lat
    ,lon
from tmp
order by
    rn desc
    ,code asc