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 
	6371 * ACOS( 
		COS(RADIANS(S.LAT)) * COS(RADIANS(A.LATITUDE)) * COS(RADIANS(A.LONGITUDE) - RADIANS(S.LON))+ SIN(RADIANS(S.LAT)) * SIN(RADIANS(A.LATITUDE))
	) DESC
,A.DISTRICT_CODE ASC