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