select l.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
where l.DISTRICT_CODE <> '1101'
order by l.LATITUDE+l.LONGITUDE desc,l.DISTRICT_CODE;