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)
)
,cal_length AS
(
SELECT
    CODE,
    NAME,
    SQRT(POW(cen_lat - LAT,2) + POW(cen_lon - LON,2)) AS length_pow,
    LAT,
    LON
FROM
    join_DISTRICT_LOCATION
)

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