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