select
    DISTRICT_CODE as CODE,
    DISTRICT_NAME as NAME,
    LATITUDE as LAT,
    LONGITUDE as LON
from (
    select
        *,
        POWER(
            POWER(LATITUDE 
                - (
                    select
                        LATITUDE
                    from
                        LOCATION_TBL 
                        join DISTRICT using (DISTRICT_CODE)
                    where
                        DISTRICT_CODE = '1101')
                , 2) 
            + POWER(LONGITUDE 
                    - (
                        select
                            LONGITUDE
                        from
                            LOCATION_TBL 
                            join DISTRICT using (DISTRICT_CODE)
                        where
                            DISTRICT_CODE = '1101')
                    , 2)
            , 0.5) as DISTANCE
    from
        LOCATION_TBL 
        join DISTRICT using (DISTRICT_CODE)
)
where
    DISTRICT_CODE != '1101'
order by
    DISTANCE desc,
    DISTRICT_CODE;