WITH kijun AS (
	SELECT 
		LATITUDE AS kijunLATITUDE
		,LONGITUDE AS kijunLONGITUDE
	FROM LOCATION_TBL
	WHERE DISTRICT_CODE = '1101'
)
,sabun AS (
SELECT *
FROM LOCATION_TBL AS t1
CROSS JOIN kijun AS t2
LEFT OUTER JOIN DISTRICT AS t3
	ON t1.DISTRICT_CODE = t3.DISTRICT_CODE
WHERE t1.DISTRICT_CODE <> '1101'
)
,sakeisan AS (
SELECT
	DISTRICT_CODE
	,DISTRICT_NAME
	,LATITUDE
	,LONGITUDE
	,kijunLATITUDE
	,kijunLONGITUDE
	,ROUND((LATITUDE-kijunLATITUDE)*(LATITUDE-kijunLATITUDE),14) AS LATITUDEsa
	,ROUND((LONGITUDE-kijunLONGITUDE)*(LONGITUDE-kijunLONGITUDE),14) AS LONGITUDEsa
FROM sabun
)
SELECT
	DISTRICT_CODE AS CODE
	,DISTRICT_NAME AS NAME
	,LATITUDE AS LAT
	,LONGITUDE AS LON
FROM sakeisan
ORDER BY SQRT(LATITUDEsa + LONGITUDEsa) DESC,DISTRICT_CODE DESC