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