select
	"CODE",
	"NAME",
	"LAT",
	"LON"
from
	(
	select
		dis.DISTRICT_CODE as "CODE",
		dis.DISTRICT_NAME as "NAME",
		LATITUDE as LAT,
		LONGITUDE as LON,
		LATITUDE - (select LATITUDE from LOCATION_TBL where DISTRICT_CODE = 1101) as LAT_DIFF,
		LONGITUDE - (select LONGITUDE from LOCATION_TBL where DISTRICT_CODE = 1101) as LON_DIFF
	from
		location_tbl loc inner join DISTRICT dis using(DISTRICT_CODE)
 ) sub
where
	"CODE" != 1101
order by
	sub.LAT_DIFF * sub.LAT_DIFF + sub.LON_DIFF * sub.LON_DIFF desc,
	"CODE" asc;