SELECT
PF_CODE AS 都道府県コード,
PF_NAME AS 都道府県名,
P1.TOTAL_AMT AS 総人口2015年,
P2.TOTAL_AMT AS 総人口2020年,
ROUND(CAST(P2.TOTAL_AMT AS FLOAT)*100 / P1.TOTAL_AMT,0) AS 人口増加率
FROM POPU_TRANSITION AS P1
JOIN POPU_TRANSITION AS P2
USING(PF_CODE)
JOIN PREFECTURE
USING(PF_CODE)
WHERE P1.SURVEY_YEAR = 2015 AND P2.SURVEY_YEAR = 2020 AND P1.TOTAL_AMT < P2.TOTAL_AMT
ORDER BY 5 DESC,1;