with base_pos as (
select l.LATITUDE as lat, l.LONGITUDE as lon
from LOCATION_TBL as l
where l.DISTRICT_CODE = '1101'
),
locate_list as (
select *
from LOCATION_TBL as l
JOIN DISTRICT as d on l.DISTRICT_CODE == d.DISTRICT_CODE
where l.DISTRICT_CODE <> '1101'
)

select l.DISTRICT_CODE as CODE, l.DISTRICT_NAME as NAME, l.LATITUDE as LAT, l.LONGITUDE as LON
from locate_list as l
cross join base_pos as b
order by SQRT(POW(l.LATITUDE-b.lat,2)+POW(l.LONGITUDE-b.lon,2)) desc, l.DISTRICT_CODE