with position_1101 as(
    select
        LATITUDE as 'LAT_1101'
        ,LONGITUDE as 'LON_1101'
    from
        LOCATION_TBL
    where
        DISTRICT_CODE = '1101'
)
, distance as(
    select
        PF_CODE 
        ,DISTRICT_CODE 
        ,LATITUDE
        ,LONGITUDE
        ,(abs(LATITUDE - LAT_1101) * abs(LONGITUDE - LON_1101) / 2.0) as 'DISTANCE'
    from
        LOCATION_TBL
        ,position_1101
)
select
    l.DISTRICT_CODE as 'CODE'
    ,DISTRICT_NAME as 'NAME'
    ,l.LATITUDE as 'LAT'
    ,l.LONGITUDE as 'LON'
from
    LOCATION_TBL l
    ,DISTRICT d
    ,distance ds
where
    l.DISTRICT_CODE  = d.DISTRICT_CODE 
    and l.PF_CODE  = ds.PF_CODE 
    and l.DISTRICT_CODE = ds.DISTRICT_CODE
    and l.DISTRICT_CODE <> '1101'
order by
    DISTANCE desc
    ,l.DISTRICT_CODE asc
;