SELECT 
    PF.PF_CODE AS 都道府県コード,
    PF.PF_NAME AS 都道府県名,
    POTR2015.TOTAL_AMT AS 総人口2015年,
    POTR2020.TOTAL_AMT AS 総人口2020年,
    ROUND((CAST(POTR2020.TOTAL_AMT AS REAL)/POTR2015.TOTAL_AMT)*100,0) AS 人口増加率
FROM
(SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) AS POTR2015
JOIN
(SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) AS POTR2020
ON POTR2015.PF_CODE = POTR2020.PF_CODE
JOIN PREFECTURE AS PF
ON POTR2020.PF_CODE = PF.PF_CODE
WHERE 人口増加率>100
ORDER BY 人口増加率 DESC, 都道府県コード ASC;