select
    t_2015.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    t_2015.total_amt as 総人口2015年,
    t_2020.total_amt as 総人口2020年,
    round(100.0 * t_2020.total_amt / t_2015.total_amt, 0) as 人口増加率
from prefecture as p
inner join
    (
        select pf_code, total_amt
        from popu_transition
        where survey_year = 2015
    ) as t_2015 on p.pf_code = t_2015.pf_code,
    (
        select pf_code, total_amt
        from popu_transition
        where survey_year = 2020
    ) as t_2020 on p.pf_code = t_2020.pf_code
where t_2015.total_amt < t_2020.total_amt
order by 5 desc, 1 asc