SELECT
    T.pf_code AS 都道府県コード
,   P.pf_name AS 都道府県名
,   T.総人口2015
,   T.総人口2020
,   T.人口増加率
FROM
(
    SELECT
        pf_code
    ,   SUM(CASE survey_year WHEN 2015 THEN total_amt ELSE 0 END) AS 総人口2015
    ,   SUM(CASE survey_year WHEN 2020 THEN total_amt ELSE 0 END) AS 総人口2020
    ,   ROUND(
            CAST(SUM(CASE survey_year WHEN 2020 THEN total_amt ELSE 0 END) AS real)
            /
            CAST(SUM(CASE survey_year WHEN 2015 THEN total_amt ELSE 0 END) AS real) * 100
        ) AS 人口増加率
    FROM
        POPU_TRANSITION
    WHERE
        survey_year IN (2015, 2020)
    GROUP BY
        pf_code
) AS T
    INNER JOIN
        PREFECTURE AS P
        ON T.pf_code = P.pf_code
WHERE
    T.総人口2015 < T.総人口2020
ORDER BY
    人口増加率 DESC
,   都道府県コード
;