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
    ,latitude as LAT
    ,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
    l.latitude * l.latitude + l.longitude * l.longitude desc
    ,1