select
    pf.pf_code as 都道府県コード,
    pf.pf_name as 都道府県名,
    pp2015.total_amt as 総人口2015年,
    pp2020.total_amt as 総人口2020年,
    round(cast(pp2020.total_amt as real) / cast(pp2015.total_amt as real) * 100) as 人口増加率
from
    popu_transition as pp2015
    inner join prefecture as pf
        on pf.pf_code = pp2015.pf_code
    inner join popu_transition as pp2020
        on pp2020.pf_code = pp2015.pf_code
        and pp2020.survey_year = 2020
where
    pp2015.survey_year = 2015
    and pp2020.total_amt >= pp2015.total_amt
order by 
    人口増加率 desc,
    pf.pf_code;