SELECT
     CODE
    ,NAME
    ,LAT
    ,LON
FROM
(
SELECT 
	 T1.DISTRICT_CODE CODE
	,T2.DISTRICT_NAME NAME
	,T1.LATITUDE LAT
	,T1.LONGITUDE LON
	,T3.LAT_WK
	,T3.LON_WK
	,CASE 
	    WHEN T1.LATITUDE > T3.LAT_WK THEN T1.LATITUDE - T3.LAT_WK
	    ELSE T3.LAT_WK - T1.LATITUDE
     END WK1
	,CASE
	    WHEN T1.LONGITUDE > T3.LON_WK THEN T1.LONGITUDE - T3.LON_WK
	    ELSE T3.LON_WK - T1.LONGITUDE
     END WK2
FROM LOCATION_TBL T1
LEFT OUTER JOIN DISTRICT T2
  ON T1.DISTRICT_CODE = T2.DISTRICT_CODE
,
(
SELECT
	 LATITUDE LAT_WK
	,LONGITUDE LON_WK
FROM LOCATION_TBL
WHERE DISTRICT_CODE = '1101' 
) T3
WHERE CODE <> '1101' 
ORDER BY WK1+WK2 DESC,CODE

)