SELECT
   T1.PF_CODE AS "都道府県コード"
  ,T2.PF_NAME AS "都道府県名"
  ,T1.TOTAL_AMT AS "総人口2015年"
  ,T3.TOTAL_AMT AS "総人口2020年"
  ,CAST(CAST(T3.TOTAL_AMT AS REAL) / CAST(T1.TOTAL_AMT AS REAL) * 100 AS INTEGER) AS "人口増加率"
FROM
  POPU_TRANSITION AS T1
INNER JOIN
  PREFECTURE AS T2 ON T1.PF_CODE=T2.PF_CODE
LEFT OUTER JOIN
  (
    SELECT
       PF_CODE
      ,TOTAL_AMT
    FROM
      POPU_TRANSITION
     WHERE
      SURVEY_YEAR = 2015
  ) AS T3 ON T1.PF_CODE = T3.PF_CODE
WHERE
  T1.SURVEY_YEAR = 2020
  AND T3.TOTAL_AMT - T1.TOTAL_AMT > 0
ORDER BY
   "人口増加率" DESC
  ,T1.PF_CODE