SELECT 
    D.DISTRICT_CODE CODE,
    D.DISTRICT_NAME NAME,
    T.LATITUDE LAT,
    T.LONGITUDE LON
FROM DISTRICT AS D
INNER JOIN LOCATION_TBL AS T
    ON D.DISTRICT_CODE = T.DISTRICT_CODE
    AND D.DISTRICT_CODE <> '1101'
CROSS JOIN LOCATION_TBL AS LT
    ON LT.DISTRICT_CODE = '1101'
ORDER BY
    (POW(LT.LATITUDE - T.LATITUDE, 2) + POW(LT.LONGITUDE - T.LONGITUDE, 2)) DESC
    ,1
;