select 
    PO.PF_CODE as 都道府県コード,
    PF.PF_NAME as 都道府県名,
    PO.TOTAL_AMT as 総人口2015年,
    PO2020.TOTAL_AMT as 総人口2020年,
    round(
        cast(PO2020.TOTAL_AMT as real) / cast(PO.TOTAL_AMT as real) * 100
    ) as 人口増加率

from POPU_TRANSITION as PO

inner join PREFECTURE as PF 
    on PF.PF_CODE = PO.PF_CODE
        
inner join POPU_TRANSITION as PO2020
    on PO2020.PF_CODE = PO.PF_CODE 
    and PO2020.SURVEY_YEAR = 2020     
        
where PO.SURVEY_YEAR = 2015 and PO2020.TOTAL_AMT >= PO.TOTAL_AMT

order by 
    人口増加率 desc, 
    都道府県コード asc;