WITH TMP1 AS(
SELECT
    DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON,
    ABS(LATITUDE - 43.044502) AS X,
    ABS(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;