select
    PR.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    POP1.TOTAL_AMT as 総人口2015年,
    POP2.TOTAL_AMT as 総人口2020年, 
    round(100.0 * POP1.TOTAL_AMT / POP2.TOTAL_AMT) as 増加率

from 
    PREFECTURE as PR
inner join
    POPU_TRANSITION as POP1 on  POP1.PF_CODE = PR.PF_CODE
inner join
    POPU_TRANSITION as POP2 on  POP2.PF_CODE = PR.PF_CODE
    
where
    POP1.SURVEY_YEAR = 2015 and POP2.SURVEY_YEAR = 2020

order by 増加率 desc,
         都道府県コード