select
    PT.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    PT.TOTAL_AMT as 総人口2015年,
    PT2.TOTAL_AMT as 総人口2020年,
    round((cast(PT2.TOTAL_AMT as real)/cast(PT.TOTAL_AMT as real))*100,0) as 人口増加率
from POPU_TRANSITION as PT
    inner join PREFECTURE  PR
        on PT.PF_CODE=PR.PF_CODE
    inner join POPU_TRANSITION as PT2 
        on PT.PF_CODE = PT2.PF_CODE 
        and PT2.SURVEY_YEAR=2020
where PT.SURVEY_YEAR=2015 and 人口増加率>=100
order by 人口増加率 desc,都道府県コード asc;