select
    D.DISTRICT_CODE as CODE,
    D.DISTRICT_NAME as NAME,
    L.LATITUDE as LAT,
    L.LONGITUDE as LON
from
    LOCATION_TBL L
    inner join DISTRICT D
    on L.DISTRICT_CODE = D.DISTRICT_CODE
    inner join LOCATION_TBL L2
    on L2.DISTRICT_CODE = '1101'
where
    L.DISTRICT_CODE != '1101'
order by
    pow(abs(L.LATITUDE - L2.LATITUDE), 2) + pow(abs(L.LONGITUDE - L2.LONGITUDE), 2) desc,
    D.DISTRICT_CODE
;