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