SELECT
  L.DISTRICT_CODE AS CODE,
  D.DISTRICT_NAME AS NAME,
  L.LATITUDE AS LAT,
  L.LONGITUDE AS LON
FROM
  LOCATION_TBL AS L
JOIN
  DISTRICT AS D ON L.DISTRICT_CODE = D.DISTRICT_CODE
WHERE
  L.DISTRICT_CODE != '1101'
GROUP BY
  L.DISTRICT_CODE
ORDER BY
  ((L.LATITUDE - (SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')) * (L.LATITUDE - (SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'))) +
  ((L.LONGITUDE - (SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')) * (L.LONGITUDE - (SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'))) DESC,
  L.DISTRICT_CODE ASC;