SELECT
  T.PF_CODE AS 都道府県コード
  , P.PF_NAME AS 都道府県名
  , T.TOTAL_AMT_2015 AS 総人口2015年
  , T.TOTAL_AMT_2020 AS 総人口2020年
  , ROUND(CAST(T.TOTAL_AMT_2020 AS REAL) / T.TOTAL_AMT_2015 * 100) AS 人口増加率
FROM
  (
    SELECT
      T2015.PF_CODE
      , T2015.TOTAL_AMT AS TOTAL_AMT_2015
      , T2020.TOTAL_AMT AS TOTAL_AMT_2020
    FROM
    (
      SELECT
        PF_CODE
        , TOTAL_AMT
      FROM
        POPU_TRANSITION
      WHERE
        SURVEY_YEAR = 2015
    ) AS T2015
    INNER JOIN
    (
      SELECT
        PF_CODE
        , TOTAL_AMT
      FROM
        POPU_TRANSITION
      WHERE
        SURVEY_YEAR = 2020
    ) AS T2020
    ON T2015.PF_CODE = T2020.PF_CODE
    WHERE
      T2015.TOTAL_AMT < T2020.TOTAL_AMT
  ) AS T
LEFT OUTER JOIN PREFECTURE AS P
  ON T.PF_CODE = P.PF_CODE
ORDER BY
  人口増加率 DESC
  , 都道府県コード
;