with tmp as (
select
    d.district_code
    ,d.district_name
    ,l.latitude
    ,l.longitude
from
    location_tbl l left join district d
    on l.district_code = d.district_code
where
    l.district_code <> '1101'
), tmp2 as (
select
    district_code
    ,latitude
    ,longitude
from
    location_tbl
where
    district_code = '1101'
), tmp3 as (
select
    t1.district_code
    ,t1.district_name
    ,sqrt(
    (t1.longitude - t2.longitude) * (t1.longitude - t2.longitude) 
    + (t1.latitude - t2.latitude) * (t1.latitude - t2.latitude)
    ) len
    ,t1.latitude
    ,t1.longitude
from
    tmp t1 left join tmp2 t2
    on t1.district_code <> t2.district_code
)
select
    district_code CODE
    ,district_name NAME
    ,latitude LAT
    ,longitude LON
from
    tmp3
order by
    len desc, district_code
;