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
    ORDER BY 5 DESC, 1;