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