WITH TEMP AS(
    SELECT
        POP.PF_CODE
        ,PF_NAME
        ,SUM(
            CASE 
                WHEN SURVEY_YEAR = 2015
                THEN TOTAL_AMT
                ELSE 0
            END 
            )AS 'Y2015'
        ,SUM(
            CASE
                WHEN SURVEY_YEAR = 2020
                THEN TOTAL_AMT
                ELSE 0
            END 
            )AS 'Y2020'
    FROM 
        POPU_TRANSITION POP
        LEFT JOIN PREFECTURE PRE
        ON POP.PF_CODE = PRE.PF_CODE
    WHERE
        SURVEY_YEAR = 2015
        OR SURVEY_YEAR = 2020
    GROUP BY 
        POP.PF_CODE
        ,PF_NAME
)
SELECT
    PF_CODE AS '都道府県コード'
    ,PF_NAME AS '都道府県名'
    ,Y2015 AS '総人口2015年'
    ,Y2020 AS '総人口2020年'
    ,ROUND(CAST(Y2020 AS REAL)*100/Y2015,0) AS '人口増加率'
FROM 
    TEMP
WHERE
    ROUND(CAST(Y2020 AS REAL)*100/Y2015,0) >= 100
ORDER BY 
    人口増加率 DESC
    ,都道府県コード ASC