--【問題9】
WITH
BASE AS(
SELECT
	A.DISTRICT_CODE
,	B.DISTRICT_NAME
,	A.LATITUDE
,	A.LONGITUDE
FROM
	LOCATION_TBL A
,	DISTRICT B
WHERE
	A.DISTRICT_CODE = B.DISTRICT_CODE
AND	A.DISTRICT_CODE = '1101'
)
SELECT
	A.DISTRICT_CODE AS CODE
,	B.DISTRICT_NAME AS NAME
,	A.LATITUDE AS LAT
,	A.LONGITUDE AS LON
FROM
	LOCATION_TBL A
,	DISTRICT B
,	BASE C
WHERE
	A.DISTRICT_CODE = B.DISTRICT_CODE
AND	A.DISTRICT_CODE <> '1101'
ORDER BY
	SQRT((A.LATITUDE - C.LATITUDE)*(A.LATITUDE - C.LATITUDE) + (A.LONGITUDE - C.LONGITUDE)*(A.LONGITUDE - C.LONGITUDE)) DESC
,	A.DISTRICT_CODE