SELECT 
    PR.PF_CODE 都道府県コード, PR.PF_NAME 都道府県名, YR15.TA15 総人口2015年, YR20.TA20  総人口2020年, ROUND(((YR20.TA20 * 100.0 )/ YR15.TA15)) 人口増加率 
    FROM (
    SELECT PF_CODE, SUM(TOTAL_AMT) TA15 FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015 GROUP BY 1) YR15 JOIN
    (SELECT PF_CODE, SUM(TOTAL_AMT) TA20
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
    GROUP BY 1) YR20 ON YR15.PF_CODE = YR20.PF_CODE
    JOIN PREFECTURE PR ON PR.PF_CODE = YR15.PF_CODE
    WHERE YR20.TA20 > YR15.TA15
    ORDER BY 5 DESC, 1;