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