SELECT
    P1.pf_code AS 都道府県コード
,   T.pf_name AS 都道府県名
,   P1.total_amt AS 総人口2015
,   P2.total_amt AS 総人口2020
,   ROUND(
        CAST(P2.total_amt AS real) / CAST(P1.total_amt AS real) * 100
    ) AS 人口増加率
FROM
    popu_transition AS P1
    INNER JOIN
        prefecture AS T
        ON P1.pf_code = T.pf_code
    INNER JOIN
        popu_transition AS P2
        ON
        P1.pf_code = P2.pf_code
        AND
        P2.survey_year = 2020
WHERE
    P1.survey_year = 2015
    AND
    P2.total_amt >= P1.total_amt
ORDER BY
    人口増加率 DESC
,   都道府県コード ASC