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