WITH kijun AS (
	SELECT 
		LATITUDE AS kijunLATITUDE
		,LONGITUDE AS kijunLONGITUDE
	FROM LOCATION_TBL
	WHERE DISTRICT_CODE = '1101'
)
,basedata AS (
SELECT 
    t1.DISTRICT_CODE
    ,t3.DISTRICT_NAME
    ,t1.LATITUDE
    ,t1.LONGITUDE
    ,t2.kijunLATITUDE
    ,t2.kijunLONGITUDE
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'
)
SELECT
	DISTRICT_CODE AS CODE
	,DISTRICT_NAME AS NAME
	,LATITUDE AS LAT
	,LONGITUDE AS LON
FROM basedata
ORDER BY
	(POW(LATITUDE - kijunLATITUDE, 2)+POW(LONGITUDE - kijunLONGITUDE, 2)) DESC
	,DISTRICT_CODE ASC