select
    t3.CODE
    ,t3.NAME
    ,t3.LAT
    ,t3.LON
from
    (select
        t2.DISTRICT_CODE as 'CODE'
        ,di.DISTRICT_NAME as 'NAME'
        ,t2.LATITUDE as 'LAT'
        ,t2.LONGITUDE as 'LON'
        ,( ABS(POWER(t1.t1_LAT-t2.LATITUDE,2)) 
         + ABS(POWER(t1.t1_LON-t2.LONGITUDE,2))) as 'DIST'
    from
        LOCATION_TBL t2
    inner join
        DISTRICT di
        on di.DISTRICT_CODE = t2.DISTRICT_CODE
    full join
        (select
             DISTRICT_CODE as 't1_CODE'
            ,LATITUDE as 't1_LAT'
            ,LONGITUDE as 't1_LON'
        from
            LOCATION_TBL
        where
            DISTRICT_CODE = '1101'
        ) t1
    where 
        t2.DISTRICT_CODE <> '1101'
    ) t3
order by
    t3.DIST desc
    ,t3.CODE asc