SELECT
  PREFECTURE.PF_CODE AS 都道府県コード,
  PREFECTURE.PF_NAME AS 都道府県名,
  survey_data.amt_2015 AS 総人口2015年,
  survey_data.amt_2020 AS 総人口2020年,
  ROUND(100*CAST(survey_data.amt_2020 AS float)/CAST(survey_data.amt_2015 AS float),1) AS 人口増加率
FROM
  (
    SELECT
      survey_2015.PF_CODE,
      survey_2015.TOTAL_AMT AS amt_2015,
      survey_2020.TOTAL_AMT AS amt_2020
    FROM
      (
        SELECT
          PF_CODE,
          TOTAL_AMT
        FROM
          POPU_TRANSITION
        WHERE
          SURVEY_YEAR = 2015
      ) AS survey_2015
    LEFT JOIN
      (
        SELECT
          PF_CODE,
          TOTAL_AMT
        FROM
          POPU_TRANSITION
        WHERE
          SURVEY_YEAR = 2020
      ) AS survey_2020
    ON
      survey_2015.PF_CODE = survey_2020.PF_CODE
    AND
      survey_2015.TOTAL_AMT < survey_2020.TOTAL_AMT
  ) AS survey_data
LEFT JOIN
  PREFECTURE
  ON  survey_data.PF_CODE = PREFECTURE.PF_CODE
ORDER BY
  人口増加率 DESC,
  都道府県コード