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
    ,sqrt(POW(l.LATITUDE - (select LATITUDE from t),2) + POW(l.LONGITUDE - (select LONGITUDE from t),2))  as rn
from LOCATION_TBL as l
inner join DISTRICT as d
on l.DISTRICT_CODE = d.DISTRICT_CODE
where l.DISTRICT_CODE != '1101'
)
select 
    code
    ,name
    ,lat
    ,lon
    -- ,rn
from tmp
order by
    rn desc
    ,code asc