WITH BASE AS 
(
SELECT 
        A.PF_CODE,
        A.DISTRICT_CODE,
        A.BASE_CODE,
        A.LATITUDE ,
        A.LONGITUDE,
        B.LATITUDE AS BASELA,
        B.LONGITUDE AS BASELO
FROM
(
    SELECT
        PF_CODE,
        DISTRICT_CODE,
        '1101' AS BASE_CODE,
        LATITUDE ,
        LONGITUDE 
    FROM
        LOCATION_TBL
) A
LEFT JOIN 
(
    SELECT
        DISTRICT_CODE,
        LATITUDE ,
        LONGITUDE 
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = '1101'
) B
ON A.BASE_CODE = B.DISTRICT_CODE
)
SELECT
    LOC.DISTRICT_CODE AS CODE,
    DIS.DISTRICT_NAME AS NAME,
    LOC.LATITUDE AS LAT,
    LOC.LONGITUDE AS LON
FROM
    (
    SELECT
        PF_CODE,
        DISTRICT_CODE ,
        LATITUDE,
        LONGITUDE,
        SQRT((CAST(LATITUDE AS REAL) - CAST(BASELA AS REAL)) * (CAST(LATITUDE AS REAL) - CAST(BASELA AS REAL)) + 
             (CAST(LONGITUDE AS REAL) - CAST(BASELO AS REAL)) * (CAST(LONGITUDE AS REAL) - CAST(BASELO AS REAL)) ) LEN
    FROM
        BASE
    WHERE
        DISTRICT_CODE <> '1101'
    ) LOC
    LEFT JOIN DISTRICT DIS
    ON LOC.DISTRICT_CODE = DIS.DISTRICT_CODE
ORDER BY
    LEN DESC
;