SELECT
TT.PF_CODE AS 都道府県コード,
PT.PF_NAME AS 都道府県名,
TT.TOTAL_AMT AS 総人口2015年,
T2020.TOTAL_AMT AS 総人口2020年,

--人口増加率を%で表示(小数点以下は四捨五入) → 人口増加率
ROUND(CAST(T2020.TOTAL_AMT AS REAL)/CAST(TT.TOTAL_AMT AS REAL) * 100) AS 人口増加率

FROM
POPU_TRANSITION AS TT

--都道府県を内部結合
INNER JOIN PREFECTURE AS PT
ON
PT.PF_CODE = TT.PF_CODE

--2020年のデータを抽出
INNER JOIN POPU_TRANSITION AS T2020
ON
T2020.PF_CODE = TT.PF_CODE
AND
T2020.SURVEY_YEAR = 2020

--2015年のデータを抽出
WHERE
TT.SURVEY_YEAR = 2015
AND
TT.TOTAL_AMT >= T2020.TOTAL_AMT

ORDER BY 人口増加率 DESC,TT.PF_CODE ASC