SELECT
    pf.PF_CODE AS 都道府県コード
    , pf.PF_NAME AS 都道府県名
    , p1.TOTAL_AMT AS 総人口2015年
    , p2.TOTAL_AMT AS 総人口2020年
    , ROUND(CAST(p2.TOTAL_AMT AS REAL) / p1.TOTAL_AMT * 100) AS 人口増加率
FROM
    POPU_TRANSITION AS p1
INNER JOIN
    POPU_TRANSITION AS p2
ON
    p1.SURVEY_YEAR = 2015
    AND p2.SURVEY_YEAR = 2020
    AND p1.PF_CODE = p2.PF_CODE
    AND p1.TOTAL_AMT < p2.TOTAL_AMT
INNER JOIN
    PREFECTURE AS pf
ON
    p1.PF_CODE = pf.PF_CODE
ORDER BY
    人口増加率 DESC, 都道府県コード ASC
;