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,
             都道府県コード