SELECT p1.pf_code "都道府県コード", prf.pf_name "都道府県名", p1.total_amt "2015年総人口", p2.total_amt "2020年総人口", p2.total_amt * 100 / p1.total_amt "人口増加率"
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;