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