SELECT p.PF_CODE AS 都道府県コード, p.PF_NAME AS 都道府県名
    , pt.TOTAL_AMT AS 総人口2015年, pt2020.TOTAL_AMT AS 総人口2020年
    , ROUND( CAST(pt2020.TOTAL_AMT AS REAL) / pt.TOTAL_AMT * 100)  AS 人口増加率 
FROM
    POPU_TRANSITION AS pt
    INNER JOIN PREFECTURE AS p ON p.PF_CODE = pt.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;