select
    PR.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    POP1.TOTAL_AMT as 総人口2015年,
    POP2.TOTAL_AMT as 総人口2020年, 
    round(100.0 * POP2.TOTAL_AMT / POP1.TOTAL_AMT) as 人口増加率
        
from 
    PREFECTURE as PR
inner join
    POPU_TRANSITION as POP1 
    on POP1.PF_CODE = PR.PF_CODE and POP1.SURVEY_YEAR = 2015
inner join
    POPU_TRANSITION as POP2 
    on POP2.PF_CODE = PR.PF_CODE and POP2.SURVEY_YEAR = 2020
    
where
    POP1.TOTAL_AMT <= POP2.TOTAL_AMT
    
order by 増加率 desc,
         都道府県コード