select
	D.DISTRICT_CODE as CODE,
	D.DISTRICT_NAME as NAME,
	C.LATITUDE as LAT,
	C.LONGITUDE as LON
from
	(
	select
		B.DISTRICT_CODE,
		power(A.LATITUDE - B.LATITUDE,2) + power(A.LONGITUDE - B.LONGITUDE,2) as dist,
		B.LATITUDE,
		B.LONGITUDE
	from
		(select LATITUDE,LONGITUDE from LOCATION_TBL L where DISTRICT_CODE = '1101') A
	cross join
		(select DISTRICT_CODE,LATITUDE,LONGITUDE from LOCATION_TBL L where DISTRICT_CODE <> '1101') B
	) C
inner join
	DISTRICT D
on
	C.DISTRICT_CODE = D.DISTRICT_CODE
order by
    C.dist desc,
    D.DISTRICT_CODE asc