select CODE,
NAME,
LAT,
LON
FROM(
select loc.DISTRICT_CODE as CODE
,dis.DISTRICT_NAME as NAME
,loc.LATITUDE as LAT
,loc.LONGITUDE as LON
,(SELECT  SQRT(POWER(loc.LATITUDE - loc2.LATITUDE,2) + POWER(loc.LONGITUDE - loc2.LONGITUDE,2)) from LOCATION_TBL loc2 WHERE DISTRICT_CODE = '1101') as kyori
from LOCATION_TBL loc
inner join DISTRICT dis 
on loc.DISTRICT_CODE = dis.DISTRICT_CODE
WHERE loc.DISTRICT_CODE != '1101'
)
order by kyori desc,CODE;