SELECT
lt.DISTRICT_CODE AS 'CODE'
,DISTRICT_NAME AS 'NAME'
,LATITUDE AS 'LAT'
,LONGITUDE AS 'LON'
FROM
LOCATION_TBL lt
INNER JOIN
DISTRICT d
ON
lt.DISTRICT_CODE = d.DISTRICT_CODE
WHERE
lt.DISTRICT_CODE NOT IN('1101')
ORDER BY
(LONGITUDE - LATITUDE) desc
,lt.DISTRICT_CODE asc
;