SELECT
  T2015.PF_CODE AS 都道府県コード,
  T2015.PF_NAME AS 都道府県名,
  T2015.TOTAL_AMT AS 総人口2015年,
  T2020.TOTAL_AMT AS 総人口2015年,
  ROUND(CAST(T2020.TOTAL_AMT AS REAL) * 100 / CAST(T2015.TOTAL_AMT AS REAL), 0) AS 人口増加率
FROM (
  SELECT
    PF_CODE,
    PF_NAME,
    SUM(TOTAL_AMT) AS TOTAL_AMT
  FROM POPU_TRANSITION INNER JOIN PREFECTURE USING (PF_CODE)
  WHERE SURVEY_YEAR = 2015
  GROUP BY PF_CODE, PF_NAME
) AS T2015
INNER JOIN (
  SELECT
    PF_CODE,
    PF_NAME,
    SUM(TOTAL_AMT) AS TOTAL_AMT
  FROM POPU_TRANSITION INNER JOIN PREFECTURE USING (PF_CODE)
  WHERE SURVEY_YEAR = 2020
  GROUP BY PF_CODE, PF_NAME
) AS T2020 USING (PF_CODE)
ORDER BY
  人口増加率 DESC,
  都道府県コード ASC