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