WITH
load_data AS(
SELECT
    PF_CODE,
    DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON
FROM LOCATION_TBL
LEFT JOIN DISTRICT
USING(DISTRICT_CODE)
),
root_area AS(
SELECT
    LAT AS ROOT_LAT,
    LON AS ROOT_LON
FROM load_data
WHERE
    CODE = '1101'
),
calc_data AS(
SELECT
    *,
    (LAT-ROOT_LAT)*(LAT-ROOT_LAT) + (LON-ROOT_LON) * (LON-ROOT_LON) AS DIST
FROM load_data
CROSS JOIN root_area
)
SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM calc_data
WHERE
    CODE != '1101'
AND
    PF_CODE = '01000'
ORDER BY DIST DESC,CODE