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