SELECT
    l1.DISTRICT_CODE AS CODE
    , d.DISTRICT_NAME AS NAME
    , l1.LATITUDE AS LAT
    , l1.LONGITUDE AS LON
FROM
    LOCATION_TBL AS l1
INNER JOIN
    LOCATION_TBL AS l2
ON
    l1.DISTRICT_CODE <> '1101'
    AND l2.DISTRICT_CODE = '1101'
INNER JOIN
    DISTRICT AS d
ON
    l1.DISTRICT_CODE = d.DISTRICT_CODE
ORDER BY
    SQRT(POWER(l1.LATITUDE - l2.LATITUDE, 2) + POWER(l1.LONGITUDE - l2.LONGITUDE, 2)) DESC, CODE ASC
;