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