select
    pf.PF_CODE as 都道府県コード,
    pf.PF_NAME as 都道府県名,
    pt15.TOTAL_AMT as 総人口2015年,
    pt20.TOTAL_AMT as 総人口2020年,
    round( 
        cast(pt20.TOTAL_AMT as float) / pt15.TOTAL_AMT * 100
    ) as 人口増加率 
FROM
    PREFECTURE as pf
inner join
    POPU_TRANSITION as pt15
    on pf.PF_CODE  = pt15.PF_CODE
        and pt15.SURVEY_YEAR = 2015
inner join POPU_TRANSITION as pt20
    on pf.PF_CODE = pt20.PF_CODE
        and pt20.SURVEY_YEAR = 2020 
where
    pt20.TOTAL_AMT > pt15.TOTAL_AMT
order by
    5 desc, 1