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