SELECT
  PT1.PF_CODE AS "都道府県コード"
  , P.PF_NAME AS "都道府県名"
  , PT1.TOTAL_AMT AS "総人口2015年"
  , PT2.TOTAL_AMT AS "総人口2020年"
  , ROUND(100*CAST(PT2.TOTAL_AMT AS REAL)/CAST(PT1.TOTAL_AMT AS REAL)) AS "人口増加率"
FROM
  POPU_TRANSITION AS PT1
INNER JOIN POPU_TRANSITION AS PT2
  ON PT1.SURVEY_YEAR != PT2.SURVEY_YEAR
  AND PT1.PF_CODE = PT2.PF_CODE
  AND PT1.SURVEY_YEAR = 2015
  AND PT2.SURVEY_YEAR = 2020
INNER JOIN PREFECTURE AS P
  ON PT1.PF_CODE = P.PF_CODE
WHERE
  PT1.SURVEY_YEAR <> 2010
  AND CAST(PT2.TOTAL_AMT AS REAL)/CAST(PT1.TOTAL_AMT AS REAL) > 1
ORDER BY
  "人口増加率" DESC, "都道府県コード" ASC;