with base_point as (
    --基準地点
    select
        LATITUDE as base_LA
        ,LONGITUDE as base_LO
    from
        LOCATION_TBL
    where
        DISTRICT_CODE = '1101'
    ),
    
    distance_list as (
    select
        l.DISTRICT_CODE as CODE
        ,sqrt(POW((l.LATITUDE - b.base_LA),2) + POW((l.LONGITUDE - b.base_LO),2)) as distance
    from
        LOCATION_TBL l
        ,base_point b
    where
        l.DISTRICT_CODE <> '1101'
    )
    
select
    l.DISTRICT_CODE as CODE
    ,d.DISTRICT_NAME as NAME
    ,l.LATITUDE as LAT
    ,l.LONGITUDE as LON
from
    LOCATION_TBL l
left join distance_list dl
    on l.DISTRICT_CODE = dl.CODE
left join DISTRICT d 
    on l.DISTRICT_CODE = d.DISTRICT_CODE
order by dl.distance desc
        ,CODE asc
;