select
	"CODE",
	"NAME",
	"LAT",
	"LOT"
from
	(
	select
		dis.DISTRICT_CODE as "CODE",
		dis.DISTRICT_NAME as "NAME",
		LATITUDE as LAT,
		LONGITUDE as LOT,
		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;