WITH population_growth AS (
  SELECT
    p.PF_CODE,
    p.PF_NAME,
    t2015.TOTAL_AMT AS 総人口2015年,
    t2020.TOTAL_AMT AS 総人口2020年,
    ROUND(((t2020.TOTAL_AMT * 1.0 / t2015.TOTAL_AMT) - 1) * 100) AS 人口増加率
  FROM
    PREFECTURE p
    JOIN POPU_TRANSITION t2015 ON p.PF_CODE = t2015.PF_CODE AND t2015.SURVEY_YEAR = 2015
    JOIN POPU_TRANSITION t2020 ON p.PF_CODE = t2020.PF_CODE AND t2020.SURVEY_YEAR = 2020
)
SELECT
  PF_CODE AS 都道府県コード,
  PF_NAME AS 都道府県名,
  総人口2015年,
  総人口2020年,
  人口増加率
FROM
  population_growth
WHERE
  人口増加率 > 0
ORDER BY
  人口増加率 DESC,
  都道府県コード ASC;