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

FROM 
    POPU_TRANSITION AS PT
    INNER JOIN PREFECTURE AS PR
    ON PT.PF_CODE = PR.PF_CODE
    
    INNER JOIN POPU_TRANSITION AS PT2020
    ON PT2020.PF_CODE = PT.PF_CODE
    AND PT2020.SURVEY_YEAR = 2020

WHERE  PT.SURVEY_YEAR = 2015
    AND PT2020.TOTAL_AMT >= PT.TOTAL_AMT
    
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC;