WITH subq AS (
--サブクエリで1101から各地点の距離数値を三平方の定理を活用して算出
    SELECT
        LT.PF_CODE
        ,LT.DISTRICT_CODE
        ,POW(LT.LATITUDE - LT1101.LATITUDE, 2) + POW(LT.LONGITUDE - LT1101.LONGITUDE, 2) AS DIS
    FROM
        LOCATION_TBL AS LT
    CROSS JOIN
        LOCATION_TBL AS LT1101
      ON
        LT1101.DISTRICT_CODE = '1101'
    WHERE
        LT.DISTRICT_CODE <> '1101'
    )
--サブクエリで求めた距離数値と地区テーブルをJOINして並び替え、地区名取得に活用
SELECT
    a.DISTRICT_CODE AS CODE
    ,D.DISTRICT_NAME AS NAME
    ,LATITUDE AS LAT
    ,LONGITUDE AS LON
FROM
    LOCATION_TBL AS a
INNER JOIN
    subq
  ON
    a.PF_CODE = subq.PF_CODE
    AND a.DISTRICT_CODE = subq.DISTRICT_CODE
LEFT OUTER JOIN
    DISTRICT AS D
  ON
    a.DISTRICT_CODE = D.DISTRICT_CODE
ORDER BY
    subq.DIS DESC
    ,a.DISTRICT_CODE ASC;