SELECT
 A.PF_CODE AS 都道府県コード,
 A.PF_NAME AS 都道府県名,
 B_2015.TOTAL_AMT AS 総人口2015年,
 B_2020.TOTAL_AMT AS 総人口2020年,
 ROUND(CAST(100 AS REAL) * B_2020.TOTAL_AMT / B_2015.TOTAL_AMT) AS 人口増加率
FROM
 PREFECTURE A
JOIN
 POPU_TRANSITION AS B_2015
ON
 A.PF_CODE = B_2015.PF_CODE
 AND
 B_2015.SURVEY_YEAR = 2015
JOIN
 POPU_TRANSITION AS B_2020
ON
 A.PF_CODE = B_2020.PF_CODE
 AND
 B_2020.SURVEY_YEAR = 2020
WHERE
 B_2015.TOTAL_AMT < B_2020.TOTAL_AMT
ORDER BY
 人口増加率 DESC,
 A.PF_CODE
;