SELECT
P.PF_CODE AS 都道府県コード
,P.PF_NAME AS 都道府県名
,T.TOTAL_AMT AS 総人口2015年
,T2020.TOTAL_AMT AS 総人口2020年
,ROUND(CAST(T2020.TOTAL_AMT AS REAL)/CAST(T.TOTAL_AMT AS REAL)*100) AS 人口増加率
FROM
POPU_TRANSITION AS T

INNER JOIN
PREFECTURE AS P
ON
T.PF_CODE = P.PF_CODE

--2020のデータを取得
INNER JOIN  POPU_TRANSITION AS T2020
ON
T2020.PF_CODE = P.PF_CODE
AND T2020.SURVEY_YEAR = 2020
--2015データ取得
WHERE
T.SURVEY_YEAR = 2015
AND T2020.TOTAL_AMT >= T.TOTAL_AMT

ORDER BY 人口増加率 DESC,都道府県コード