SELECT
pref.pf_code as 都道府県コード,
pf_name as 都道府県名,
a.total_amt as 総人口2015年,
b.total_amt as 総人口2020年,
round(100.0*b.total_amt/a.total_amt) as 人口増加率
FROM prefecture pref
JOIN popu_transition a
    ON a.pf_code = pref.pf_code
JOIN popu_transition b
    ON b.pf_code = pref.pf_code
WHERE a.survey_year = 2015
    AND b.survey_year = 2020
    AND b.total_amt > a.total_amt
ORDER BY
    人口増加率 DESC, pref.pf_code