SELECT
    pt1.pf_code AS 都道府県コード,
    pf_name AS 都道府県名,
    pt1.total_amt AS 総人口2015年,
    pt2.total_amt AS 総人口2020年,
    ROUND(CAST((pt2.total_amt) AS REAL) / CAST(pt1.total_amt AS REAL) * 100) AS 人口増加率
FROM
    popu_transition AS pt1
INNER JOIN
    popu_transition AS pt2
    ON pt1.pf_code = pt2.pf_code AND pt2.survey_year = 2020
INNER JOIN
    prefecture USING (pf_code)
WHERE
    pt1.survey_year = 2015
    AND pt1.total_amt < pt2.total_amt
ORDER BY
    人口増加率 DESC;