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