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