WITH SAPPORO AS(
	SELECT
		LATITUDE LAT,LONGITUDE LON
	FROM LOCATION_TBL
	WHERE DISTRICT_CODE = '1101'
)
SELECT 
	A.DISTRICT_CODE CODE
	,DISTRICT_NAME NAME
	,LATITUDE LAT
	,LONGITUDE LON
FROM LOCATION_TBL A,DISTRICT B,SAPPORO S
WHERE A.DISTRICT_CODE = B.DISTRICT_CODE
AND A.DISTRICT_CODE <> '1101'
ORDER BY 
	((S.LAT-A.LATITUDE)*(S.LAT-A.LATITUDE)+(S.LON-A.LONGITUDE)*(S.LON-A.LONGITUDE))/((S.LAT-A.LATITUDE)*(S.LAT-A.LATITUDE)+(S.LON-A.LONGITUDE)*(S.LON-A.LONGITUDE))
	 DESC
,A.DISTRICT_CODE ASC