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
--        ,d.DISTRICT_NAME as NAME
        ,l.LATITUDE as LAT
        ,l.LONGITUDE as LON
--        ,abs(l.LATITUDE - base_LA) + abs(l.LONGITUDE - base_LO) as distance
        ,sqrt(POW((l.LATITUDE - base_LA),2) + POW((l.LONGITUDE - base_LO),2)) as distance
    from
        LOCATION_TBL l
        ,base_point
--        left join DISTRICT d on l.DISTRICT_CODE = d.DISTRICT_CODE
    where
--        l.PF_CODE = '01000'
         l.DISTRICT_CODE <> '1101'
    )
select
    CODE as CODE
    ,d.DISTRICT_NAME as NAME
    ,LAT as LAT
    ,LON as LON
--    ,distance
from distance_list l
left join DISTRICT d on l.CODE = d.DISTRICT_CODE
order by distance desc
        ,CODE asc
;