SELECT
  DISTRICT_TBL.DISTRICT_CODE AS CODE,
  district.DISTRICT_NAME AS NAME,
  DISTRICT_TBL.LATITUDE AS LAT,
  DISTRICT_TBL.LONGITUDE AS LON
FROM
  (
    SELECT
      PF_CODE,
      DISTRICT_CODE,
      LATITUDE,
      LONGITUDE,
      (
        (LATITUDE - (
          SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'
        )) * (LATITUDE - (
          SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'
        ))) + (
        (LONGITUDE - (
          SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'
        )) * (LONGITUDE - (
          SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101'
        )))
        AS DISTANCE
    FROM
      LOCATION_TBL
    WHERE
      DISTRICT_CODE <> '1101'
  ) DISTRICT_TBL
   left join DISTRICT on district.DISTRICT_CODE = DISTRICT_TBL.DISTRICT_CODE
ORDER BY
  DISTRICT_TBL.DISTANCE DESC,
  DISTRICT_TBL.DISTRICT_CODE ASC;