WITH
load_data AS(
SELECT
    DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON,
    (LATITUDE-43.044502)*(LATITUDE-43.044502)+  (LONGITUDE - 141.354139) * (LONGITUDE - 141.354139) AS DIST
FROM LOCATION_TBL
LEFT JOIN DISTRICT
USING(DISTRICT_CODE)
)
-- root_area AS(
-- SELECT
--     *
-- FROM load_data
-- WHERE
--     CODE = '1101'
-- )
-- 43.044502	141.354139
SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM load_data
WHERE
    CODE != '1101'
ORDER BY DIST DESC,CODE