WITH POP_2015 AS (
  SELECT
    PF_CODE,
    TOTAL_AMT AS AMT2015
  FROM
    POPU_TRANSITION
  WHERE
    SURVEY_YEAR = 2015
),
POP_2020 AS (
  SELECT
    PF_CODE,
    TOTAL_AMT AS AMT2020
  FROM
    POPU_TRANSITION
  WHERE
    SURVEY_YEAR = 2020
)
SELECT
  pr.PF_CODE AS 都道府県コード,
  pr.PF_NAME AS 都道府県名,
  POP_2015.AMT2015 AS 総人口2015年,
  POP_2020.AMT2020 AS 総人口2020年,
  ROUND((1+(CAST(POP_2020.AMT2020 - POP_2015.AMT2015 AS REAL)/ CAST(POP_2015.AMT2015 AS REAL))) * 100) AS 人口増加率
FROM
  PREFECTURE AS pr
INNER JOIN
  POP_2015 ON pr.PF_CODE = POP_2015.PF_CODE
INNER JOIN
  POP_2020 ON pr.PF_CODE = POP_2020.PF_CODE
WHERE
  人口増加率 > 100
ORDER BY
  人口増加率 DESC,
  pr.PF_CODE ASC;