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