WITH W1 AS(
SELECT
 LATITUDE AS LAT
,LONGITUDE AS LON
FROM LOCATION_TBL
WHERE DISTRICT_CODE = '1101'
)
,W2 AS(
SELECT
 DISTRICT_CODE
,POW(ABS(LATITUDE - LAT), 2) + POW(ABS(LONGITUDE - LON), 2) AS DIS
FROM LOCATION_TBL
LEFT JOIN W1
WHERE DISTRICT_CODE <> '1101'
)

SELECT
 W2.DISTRICT_CODE AS CODE
,DIS.DISTRICT_NAME AS NAME
,LOC.LATITUDE AS LAT
,LOC.LONGITUDE AS LON
FROM W2
LEFT JOIN DISTRICT AS DIS
ON W2.DISTRICT_CODE = DIS.DISTRICT_CODE
LEFT JOIN LOCATION_TBL AS LOC
ON W2.DISTRICT_CODE = LOC.DISTRICT_CODE
ORDER BY W2.DIS DESC, W2.DISTRICT_CODE ASC
;