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 総人口2020年 > 総人口2015年
ORDER BY 5 DESC, 1