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;