SELECT p.PF_CODE 都道府県コード, p.PF_NAME 都道府県名, sum2015 '総人口2015年', sum2020 総人口2020年, ROUND(sum2020 * 100.0 / sum2015) 人口増加率
FROM PREFECTURE p
JOIN
(SELECT PF_CODE, SUM(TOTAL_AMT) sum2015
FROM POPU_TRANSITION
WHERE SURVEY_YEAR = 2015
GROUP BY PF_CODE) pt2015
ON p.PF_CODE = pt2015.PF_CODE
JOIN
(SELECT PF_CODE, SUM(TOTAL_AMT) sum2020
FROM POPU_TRANSITION
WHERE SURVEY_YEAR = 2020
GROUP BY PF_CODE) pt2020
ON p.PF_CODE = pt2020.PF_CODE
ORDER BY 人口増加率 DESC, p.PF_CODE