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
WHERE t1.DISTRICT_CODE <> '1101'
)
,sakeisan AS (
SELECT
	DISTRICT_CODE
	,LATITUDE
	,LONGITUDE
	,kijunLATITUDE
	,kijunLONGITUDE
	,ABS(LATITUDE - kijunLATITUDE) AS LATITUDEsa
	,ABS(LONGITUDE - kijunLONGITUDE) AS LONGITUDEsa
FROM sabun
)
SELECT
	t1.DISTRICT_CODE AS CODE
	,t2.DISTRICT_NAME AS NAME
	,t1.LATITUDE AS LAT
	,t1.LONGITUDE AS LON
FROM sakeisan AS t1
LEFT OUTER JOIN DISTRICT AS t2
	ON t1.DISTRICT_CODE = t2.DISTRICT_CODE
ORDER BY (t1.LATITUDEsa*t1.LATITUDEsa + t1.LONGITUDEsa*t1.LONGITUDEsa) DESC,t1.DISTRICT_CODE DESC