select
    PT.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    PT.TOTAL_AMT as 総人口2015年,
    PT2.TOTAL_AMT as 総人口2020年,
    round(cast(PT2.TOTAL_AMT*100 as real)/cast(PT.TOTAL_AMT as real),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