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