with base as(
select
  LATITUDE as LAT
  , LONGITUDE as LON
from
  LOCATION_TBL
where
  DISTRICT_CODE = '1101'
)
select
 acos(
   cos( radians(base.LAT) ) * cos( radians( a.LATITUDE ) ) * cos( radians( a.LONGITUDE ) - radians(base.LON) ) + 
   sin( radians(base.LAT) ) * sin( radians( a.LATITUDE ) ) 
 ) distance
 , a.DISTRICT_CODE as CODE
 , b.DISTRICT_NAME as NAME
 , a.LATITUDE as LAT
 , a.LONGITUDE as LON
from
  base join 
  LOCATION_TBL a
    left join DISTRICT b on a.DISTRICT_CODE = b.DISTRICT_CODE
where
  a.DISTRICT_CODE != '1101'
order by
  distance desc
  , a.DISTRICT_CODE
;