with tbl1101 as (
    select
        LATITUDE
        ,LONGITUDE
    from
        LOCATION_TBL
    where
        DISTRICT_CODE="1101"
)
,base as (
    select
        t.DISTRICT_CODE as CODE
        ,t.LATITUDE as LAT
        ,t.LONGITUDE as LON
        ,pow(t.LATITUDE - t1.LATITUDE,2) + pow(t.LONGITUDE - t1.LONGITUDE,2) as DIST
    from
        LOCATION_TBL as t
        cross join
        tbl1101 as t1
    where
        DISTRICT_CODE!="1101"
)
select
    b.CODE
    ,d.DISTRICT_NAME as NAME
    ,LAT
    ,LON
from
    base as b
    inner join
    DISTRICT as d
    on b.CODE=d.DISTRICT_CODE
order by
    DIST desc
    ,b.CODE