SELECT 
    A.PF_CODE AS '都道府県コード',
    A.PF_NAME AS '都道府県名',
    A.TOTAL_AMT AS '総人口2015年',
    B.TOTAL_AMT AS '総人口2020年',
    ROUND(CAST(B.TOTAL_AMT as real)*100 / cast(A.TOTAL_AMT as real),0) AS '人口増加率'
FROM (
    SELECT
        PT.PF_CODE,
        PT.TOTAL_AMT,
        P.PF_NAME
    FROM 
        POPU_TRANSITION PT
        JOIN PREFECTURE P ON PT.PF_CODE = P.PF_CODE
    WHERE 
        PT.SURVEY_YEAR = 2015
) AS A
JOIN (
    SELECT 
        PF_CODE,
        TOTAL_AMT
    FROM 
        POPU_TRANSITION
    WHERE 
        SURVEY_YEAR = 2020
) AS B ON A.PF_CODE = B.PF_CODE
WHERE 人口増加率 >= 100
ORDER BY 人口増加率 DESC,都道府県コード