with dist as (
    select
        b.district_code
        , D.district_name
        , b.latitude
        , b.longitude
        -- , (
        -- 6371 * ACOS(
        -- COS(RADIANS(a.latitude)) * COS(RADIANS(b.latitude)) * COS(RADIANS(b.longitude) - RADIANS(a.longitude))
        -- + SIN(RADIANS(a.latitude)) * SIN(RADIANS(b.latitude))
        -- )
        -- ) as distance
        , sqrt(power(b.latitude - a.latitude, 2) + power(b.longitude - a.longitude, 2)) as distance
    from (
        select
            district_code
            , latitude
            , longitude
        from location_tbl
        where district_code = '1101'
    ) as a
    inner join location_tbl as b
        on a.district_code <> b.district_code
    inner join district as D
        on b.district_code = D.district_code
), format as (
    select
        district_code
        , district_name
        , latitude
        , longitude
        , distance
        , rank() over (order by distance desc) as rank
    from dist
)
select
    district_code as CODE
    , district_name as NAME
    , latitude as LAT
    , longitude as LON
from format
order by rank, district_code
;