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