WITH SAPPORO as (
    SELECT
         LATITUDE   AS SAPPORO_LAT
        ,LONGITUDE  AS SAPPORO_LON
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = '1101'
)
SELECT
     LOCATION_TBL.DISTRICT_CODE AS CODE
    ,DISTRICT.DISTRICT_NAME     AS NAME
    ,LOCATION_TBL.LATITUDE      AS LAT
    ,LOCATION_TBL.LONGITUDE     AS LON
FROM
    SAPPORO
CROSS JOIN LOCATION_TBL
INNER JOIN DISTRICT
ON  LOCATION_TBL.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
AND LOCATION_TBL.DISTRICT_CODE <> '1101'

ORDER BY 
    (
        (LOCATION_TBL.LATITUDE - SAPPORO.SAPPORO_LAT)*(LOCATION_TBL.LATITUDE - SAPPORO.SAPPORO_LAT)
       +(LOCATION_TBL.LONGITUDE - SAPPORO.SAPPORO_LON)*(LOCATION_TBL.LONGITUDE - SAPPORO.SAPPORO_LON)
    )DESC
    ,LOCATION_TBL.DISTRICT_CODE ASC