WITH DIS AS(
SELECT
    L.DISTRICT_CODE
    ,L.LATITUDE AS LAT
    ,L.LONGITUDE AS LOG
    ,SQRT(POWER(L.LATITUDE - T.LATITUDE,2) + POWER(L.LONGITUDE - T.LONGITUDE,2)) AS DISTANCE
FROM
    LOCATION_TBL AS L
INNER JOIN
    LOCATION_TBL AS T
ON
    T.DISTRICT_CODE = '1101'
WHERE
    L.DISTRICT_CODE != '1101'
)
SELECT
    D.DISTRICT_CODE AS CODE
    ,D.DISTRICT_NAME AS NAME
    ,DIS.LAT
    ,DIS.LOG
FROM
    DISTRICT AS D
JOIN
    DIS AS DIS
ON
    D.DISTRICT_CODE = DIS.DISTRICT_CODE
ORDER BY
    DISTANCE DESC
    ,D.DISTRICT_CODE ASC;