SELECT p1.PF_CODE AS 都道府県コード, p.PF_NAME AS 都道府県名, p1.TOTAL_AMT AS 総人口2015年, p2.TOTAL_AMT AS 総人口2020年, round(p2.TOTAL_AMT * 100.0 / p1.TOTAL_AMT, 0) AS 人口増加率
FROM POPU_TRANSITION p1
INNER JOIN POPU_TRANSITION p2
ON p1.PF_CODE = p2.PF_CODE
INNER JOIN PREFECTURE p
ON p.PF_CODE = p1.PF_CODE
WHERE p1.SURVEY_YEAR = 2015
AND p2.SURVEY_YEAR = 2020
AND p2.TOTAL_AMT > p1.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード