with long as (
	select *
		,pow(cast(LATITUDE as real) - cast((select LATITUDE from LOCATION_TBL where DISTRICT_CODE = '1101') as real),2)
		as x2
		,pow(cast(LONGITUDE as real) - cast((select LONGITUDE from LOCATION_TBL where DISTRICT_CODE = '1101') as real),2)
		as y2
	from LOCATION_TBL
)
select d.DISTRICT_CODE as CODE
	,d.DISTRICT_NAME as NAME
	,l.LATITUDE as LAT
	,l.LONGITUDE as LON
from DISTRICT as d
left outer join long as l on d.DISTRICT_CODE = l.DISTRICT_CODE
where (not d.DISTRICT_CODE = '1101') and LAT is not null
order by x2+y2 desc ,d.DISTRICT_CODE