select
x.CODE
,x.NAME
,x.LAT
,x.LON
from
(
select
a.DISTRICT_CODE as CODE
,a.DISTRICT_NAME as NAME
,b.LATITUDE as LAT
,b.LONGITUDE as LON
,(cast(c.LONGITUDE as real) + cast(c.LATITUDE as real) + cast(b.LONGITUDE as real) + cast(b.LATITUDE as real)) as kyori
from
DISTRICT a
inner join
LOCATION_TBL b
on
a.DISTRICT_CODE = b.DISTRICT_CODE
inner join
(select * from LOCATION_TBL where DISTRICT_CODE = '1101') c
) x
where
x.CODE <> '1101'
order by
kyori desc
,CODE asc
;