select PT.PF_CODE AS 都道府県コード
,PF.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) AS 人口増加率
FROM POPU_TRANSITION AS PT
inner join PREFECTURE AS PF
    on PT.PF_CODE = PF.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
    , PT.PF_CODE ASC;