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