select
    t_2015.PF_CODE as 都道府県コード,
    p.PF_NAME as 都道府県名,
    t_2015.TOTAL_AMT as 総人口2015年,
    t_2020.TOTAL_AMT as 総人口2020年,
    round(
        cast(t_2020.TOTAL_AMT as real) /  cast(t_2015.TOTAL_AMT as real) * 100
    )
        as 人口増加率
from
    POPU_TRANSITION t_2015
    inner join
        PREFECTURE p
        on p.PF_CODE = t_2015.PF_CODE
    inner join
        POPU_TRANSITION t_2020
        on t_2020.PF_CODE = t_2015.PF_CODE
        and t_2020.SURVEY_YEAR = 2020
where
    t_2015.SURVEY_YEAR = 2015
    and t_2015.TOTAL_AMT <= t_2020.TOTAL_AMT
order by 人口増加率 desc, p.PF_CODE;