WITH prep AS(
    SELECT
        PF_CODE,
        DISTRICT_CODE,
        LATITUDE,
        (SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') AS S_LATITUDE,
        LONGITUDE,
        (SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') AS S_LONGITUDE
    FROM
        LOCATION_TBL
),
math AS(
SELECT
    PF_CODE,
    DISTRICT_CODE,
    LATITUDE,
    LONGITUDE,
    SQRT(POW((LATITUDE - S_LATITUDE),2) + POW((LONGITUDE - S_LONGITUDE),2)) AS LONG
FROM
    prep
WHERE
    DISTRICT_CODE != 1101
)
SELECT
    d.DISTRICT_CODE AS CODE,
    d.DISTRICT_NAME AS NAME,
    m.LATITUDE AS LAT,
    m.LONGITUDE AS LON
FROM
    math m
    INNER JOIN
    DISTRICT d
    ON m.DISTRICT_CODE = d.DISTRICT_CODE
ORDER BY
    m.LONG DESC,1 ASC
    ;