with LOC_1101 as(
select
	 LATITUDE  LAT_1101
	,LONGITUDE LON_1101
from
	LOCATION_TBL
where
	DISTRICT_CODE = '1101'
)
select
	L.DISTRICT_CODE CODE
   ,D.DISTRICT_NAME NAME
   ,L.LATITUDE LAT
   ,L.LONGITUDE LON
   --,sqrt(pow(L1.LAT_1101-L.LATITUDE, 2) + pow(L1.LON_1101-L.LONGITUDE, 2))
from
	LOCATION_TBL L
	inner join DISTRICT D
	on  L.DISTRICT_CODE  = D.DISTRICT_CODE
	cross join LOC_1101 L1
where
	L.DISTRICT_CODE <> '1101'
order by
	sqrt(pow(L1.LAT_1101-L.LATITUDE, 2) + pow(L1.LON_1101-L.LONGITUDE, 2)) desc
   ,CODE
;