with kijun as (
  select
      LATITUDE      as LAT
    , LONGITUDE     as LON
  from
      LOCATION_TBL
  where
      DISTRICT_CODE = '1101'

), daihukutyou as (
  select
      l.DISTRICT_CODE as CODE
    , d.DISTRICT_NAME as NAME
    , l.LATITUDE      as LAT
    , l.LONGITUDE     as LON
    , k.LAT           as O_LAT
    , k.LON           as O_LON
  from
                 LOCATION_TBL l
      inner join DISTRICT     d using(DISTRICT_CODE)
      , kijun        k
  where
      l.DISTRICT_CODE != '1101'

), kyori as (
  
  select
      CODE
    , NAME
    , LAT
    , LON
    ,   (LAT - O_LAT)
      * (LAT - O_LAT)
      + (LON - O_LON)
      * (LON - O_LON) as dist
  from
      daihukutyou
)
select
    CODE
  , NAME
  , LAT
  , LON
from
    kyori
order by 
    dist desc
  , CODE asc
;