WITH TMP1 AS(
SELECT
    D.DISTRICT_CODE AS CODE,
    D.DISTRICT_NAME AS NAME,
    L.LATITUDE AS LAT,
    L.LONGITUDE AS LON,
    ABS(L.LATITUDE - 43.044502) AS X,
    ABS(L.LONGITUDE - 141.354139) AS Y
FROM
    DISTRICT AS D
JOIN
    LOCATION_TBL AS L
USING
    (DISTRICT_CODE)
),
TMP2 AS(
SELECT
    *,
    SQRT(X*X + Y*Y) AS DISTANCE
FROM
    TMP1
)
SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM
    TMP2
WHERE
    CODE != 1101
ORDER BY
    DISTANCE DESC,
    CODE ASC;