WITH TYUOKU AS (
    SELECT
        LATITUDE AS LA
        , LONGITUDE AS LO
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = 1101
)

SELECT
    DIST_CALC.DISTRICT_CODE AS CODE
    , DISTRICT.DISTRICT_NAME AS NAME
    , DIST_CALC.LATITUDE AS LAT
    , DIST_CALC.LONGITUDE AS LON
FROM (
    SELECT
        LT.DISTRICT_CODE
        , LT.LATITUDE
        , LT.LONGITUDE
        -- 2点AB間の距離 AB = √( (x2-x1)^2 + (y2-y1)^2 )
        , SQRT(POW(TYUOKU.LA - LT.LATITUDE, 2) + POW(TYUOKU.LO - LT.LONGITUDE, 2))
            AS DIST
    FROM
        LOCATION_TBL AS LT
    CROSS JOIN
        TYUOKU
) AS DIST_CALC
INNER JOIN
    DISTRICT ON DIST_CALC.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
WHERE
    DIST_CALC.DISTRICT_CODE != 1101
ORDER BY
    DIST_CALC.DIST DESC
    , CODE ASC
;