select
    pt.pf_code as 都道府県コード,
    pr.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
    left outer join 
        prefecture as pr
    on 
        pt.pf_code = pr.pf_code
    left outer join
        popu_transition as pt2020
    on
        pt.pf_code = pt2020.pf_code
        and pt2020.survey_year = 2020
where 
    pt.survey_year = 2015
    and pt2020.total_amt >= pt.total_amt
order by 
    人口増加率 desc ,
    都道府県コード asc;