WITH POPU_2015 AS(
    SELECT
        PF_CODE
        ,SUM(TOTAL_AMT) AS TOTAL_AMT_2015
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015
    GROUP BY 
        PF_CODE
)

,POPU_2020 AS(
    SELECT
        PF_CODE
        ,SUM(TOTAL_AMT) AS TOTAL_AMT_2020
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
    GROUP BY 
        PF_CODE
)

SELECT
    PF_CODE AS "都道府県コード"
    ,PF_NAME AS "都道府県名"
    ,TOTAL_AMT_2015 AS "総人口2015年"
    ,TOTAL_AMT_2020 AS "総人口2020年"
    ,ROUND(CAST(TOTAL_AMT_2020 AS REAL) / CAST(TOTAL_AMT_2015 AS REAL) * 100, 0) AS "人口増加率"
FROM POPU_2015 NATURAL JOIN POPU_2020 JOIN PREFECTURE USING(PF_CODE)
WHERE ROUND(CAST(TOTAL_AMT_2020 AS REAL) / CAST(TOTAL_AMT_2015 AS REAL) * 100, 0) > 100
ORDER BY 5 DESC, 1;