SELECT
  b.PF_CODE 都道府県コード,
  PF_NAME 都道府県名,
  b.TOTAL_AMT 総人口2015年,
  a.TOTAL_AMT 総人口2020年,
  ROUND((CAST(a.TOTAL_AMT AS REAL) / CAST(b.TOTAL_AMT AS REAL)) * 100, 0) 人口増加率
FROM
  POPU_TRANSITION b
INNER JOIN
  POPU_TRANSITION a ON a.PF_CODE = b.PF_CODE
  AND b.SURVEY_YEAR = 2015
  AND a.SURVEY_YEAR = 2020
INNER JOIN
  PREFECTURE p ON p.PF_CODE = b.PF_CODE
WHERE
  ROUND((CAST(a.TOTAL_AMT AS REAL) / CAST(b.TOTAL_AMT AS REAL)) * 100, 0) > 100
ORDER BY
  人口増加率 DESC,
  b.PF_CODE;