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