SELECT CODE, NAME, LAT, LON
FROM (
    SELECT L.DISTRICT_CODE AS CODE, D.DISTRICT_NAME AS NAME, L.LATITUDE AS LAT, L.LONGITUDE AS LON,
    POWER(L.LATITUDE - (SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'), 2) +
    POWER(L.LONGITUDE - (SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'), 2) AS DISTANCE
    FROM LOCATION_TBL L JOIN DISTRICT D ON L.DISTRICT_CODE = D.DISTRICT_CODE
    WHERE L.DISTRICT_CODE <> '1101'
    ORDER BY DISTANCE DESC, L.DISTRICT_CODE
);