WITH 札幌市中央区 AS(
	SELECT
		DISTRICT_CODE AS CODE
		, LATITUDE AS LAT
		, LONGITUDE AS LON
	FROM
		LOCATION_TBL
	WHERE
		PF_CODE = '01000'
		AND DISTRICT_CODE = '1101'
)
SELECT
    LT.CODE
    , NAME
	, LT.LAT
	, LT.LON
FROM (
    SELECT
    	LT.DISTRICT_CODE AS CODE
    	, DISTRICT_NAME AS NAME
    	, LT.LATITUDE AS LAT
    	, LT.LONGITUDE AS LON
    	, ABS(LT.LATITUDE - 札幌市中央区.LAT) + ABS(LT.LONGITUDE - 札幌市中央区.LON) AS DISTANCE
    FROM
    	LOCATION_TBL LT, 札幌市中央区
        INNER JOIN
            DISTRICT D
            ON D.DISTRICT_CODE = LT.DISTRICT_CODE
    WHERE
    	LT.PF_CODE = '01000'
    	AND LT.DISTRICT_CODE <> '1101'
) LT
ORDER BY
    LT.DISTANCE DESC
    , LT.CODE
;