with 
    A as (
        select
            *
        from 
            LOCATION_TBL
        where
            DISTRICT_CODE != '1101' 
    ),
    B as (
        select
            *
        from 
            LOCATION_TBL
        where
            DISTRICT_CODE = '1101' 
    ),
    X as (
        select
            A.PF_CODE,
            A.DISTRICT_CODE,
            A.LATITUDE,
            A.LONGITUDE,
            POW(A.LATITUDE - B.LATITUDE, 2) + POW(A.LONGITUDE - B.LONGITUDE, 2) as DIST
        from
            A, B
    )

select
    DISTRICT.DISTRICT_CODE as CODE,
    DISTRICT.DISTRICT_NAME as NAME,
    X.LATITUDE as LAT,
    X.LONGITUDE as LON
from
    DISTRICT join X using(DISTRICT_CODE)
order by
    DIST desc,
    DISTRICT_CODE
;