select
    pr.PF_CODE as 都道府県コード
    ,PF_NAME as 都道府県名
    ,pt2015.TOTAL_AMT as 総人口2015年
    ,pt2020.TOTAL_AMT as 総人口2020年
    ,round(100.0 * pt2020.TOTAL_AMT / pt2015.TOTAL_AMT) as 人口増加率
from
    PREFECTURE as pr
    inner join POPU_TRANSITION as pt2015
        on pr.PF_CODE = pt2015.PF_CODE
        and pt2015.SURVEY_YEAR = 2015
    inner join POPU_TRANSITION as pt2020
        on pr.PF_CODE = pt2020.PF_CODE
        and pt2020.SURVEY_YEAR = 2020
where
    round(100.0 * pt2020.TOTAL_AMT / pt2015.TOTAL_AMT) > 100
order by
    人口増加率 desc
    ,都道府県コード