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