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