WITH join_DISTRICT_LOCATION AS
(
SELECT
    l.DISTRICT_CODE AS CODE,
    d.DISTRICT_NAME AS NAME,
    l.LATITUDE AS LAT,
    l.LONGITUDE AS LON,
    43.044502 AS cen_lat,
    141.354139 AS cen_lon
FROM
    LOCATION_TBL AS l
    LEFT OUTER JOIN
        DISTRICT AS d
        USING(DISTRICT_CODE)
WHERE
    CODE != '1101'
)
,cal_length AS
(
SELECT
    CODE,
    NAME,
    SQRT(POW(abs(cen_lat - LAT),2) + POW(abs(cen_lon - LON),2)) AS length_pow,
    LAT,
    LON
FROM
    join_DISTRICT_LOCATION

)
SELECT
    CODE,
    NAME,
    length_pow,
    LAT,
    LON
FROM
    cal_length
ORDER BY
    length_pow DESC,
    CODE ASC