WITH old AS (
  SELECT
    PF_CODE,
    TOTAL_AMT
  FROM
    POPU_TRANSITION
  WHERE
    SURVEY_YEAR = 2015
),

new AS (
  SELECT
    PF_CODE,
    TOTAL_AMT
  FROM
    POPU_TRANSITION
  WHERE
    SURVEY_YEAR = 2020
)

SELECT
  new.PF_CODE 都道府県コード,
  pref.PF_NAME 都道府県名,
  old.TOTAL_AMT 総人口2015年,
  new.TOTAL_AMT 総人口2020年,
  ROUND(
    CAST(new.TOTAL_AMT AS REAL) / CAST(old.TOTAL_AMT AS REAL) * 100
  ) 人口増加率
FROM new
INNER JOIN old ON new.PF_CODE = old.PF_CODE
LEFT JOIN PREFECTURE pref ON new.PF_CODE = pref.PF_CODE
WHERE 人口増加率 > 100
ORDER BY 5 DESC, 1