SELECT
     WK.CODE
   , D.DISTRICT_NAME AS NAME
   , WK.LAT
   , WK.LON
--   , WK.KYORI 
FROM
   ( 
      SELECT
           L.CODE
         , L.LAT
         , L.LON
         , L2.LAT2
         , L2.LON2
         , POW(LAT - LAT2, 2) + POW(LON - LON2, 2) AS KYORI 
      FROM
         ( 
            SELECT
                 DISTRICT_CODE AS CODE
               , LATITUDE      AS LAT
               , LONGITUDE     AS LON 
            FROM
               LOCATION_TBL 
            WHERE
               DISTRICT_CODE <> '1101'
         ) AS L
         , ( 
            SELECT
                 LATITUDE  AS LAT2
               , LONGITUDE AS LON2 
            FROM
               LOCATION_TBL 
            WHERE
               DISTRICT_CODE = '1101'
         ) AS L2
   ) AS WK
   , DISTRICT AS D 
WHERE
   WK.CODE = D.DISTRICT_CODE 
ORDER BY
   WK.KYORI DESC
   , WK.CODE ASC
;