with
    a as (
        select
            latitude as lat_1101
            ,longitude as lon_1101
        from
            location_tbl
        where
            district_code = '1101'
    )
select
    l.district_code as CODE
    ,d.district_name as NAME
    ,l.latitude as LAT
    ,l.longitude as LON
from
    location_tbl l
cross join
    a
left join
    district d
on
    l.district_code = d.district_code
where
    l.district_code != '1101'
order by
    (pow(l.latitude - a.lat_1101, 2) + pow(l.longitude - a.lon_1101, 2)) desc
    ,1 asc