WITH DIST AS(
    SELECT 
        L.DISTRICT_CODE as DISTRICT_CODE,
        (L.LATITUDE-43.044502)*(L.LATITUDE-43.044502)+(L.LONGITUDE-141.354139)*(L.LONGITUDE-141.354139) AS dist
    FROM
        LOCATION_TBL as L
)
SELECT
    DISTRICT.DISTRICT_CODE as CODE,
    DISTRICT_NAME as NAME,
    LATITUDE as LAT,
    LONGITUDE as LON,
    dist
FROM
    DISTRICT
    INNER JOIN LOCATION_TBL on DISTRICT.DISTRICT_CODE=LOCATION_TBL.DISTRICT_CODE
    INNER JOIN DIST on DISTRICT.DISTRICT_CODE=DIST.DISTRICT_CODE
WHERE 
    DISTRICT.DISTRICT_CODE <> 1101
ORDER BY
    DIST.dist DESC,
    DISTRICT.DISTRICT_CODE