with
CD1101 as (
select
    LATITUDE
    ,LONGITUDE
from
    LOCATION_TBL
where
    DISTRICT_CODE='1101'
)
,CALC_DIST as (
select
    L.DISTRICT_CODE
    ,L.LATITUDE
    ,L.LONGITUDE
    ,power(L.LATITUDE - C.LATITUDE,2) + power(L.LONGITUDE - C.LONGITUDE, 2) as DIST 
from
    LOCATION_TBL L
    cross join
        CD1101 C
where
    L.DISTRICT_CODE <> '1101'
)
select
    C.DISTRICT_CODE as CODE
    ,D.DISTRICT_NAME as NAME
    ,Latitude as LAT 
    ,Longitude as LON
from
    CALC_DIST C 
    inner join
        DISTRICT D 
        on 
            C.district_code = D.district_code
order by DIST desc, C.DISTRICT_CODE