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