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;