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)) 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
    AND
    人口増加率 > 100
ORDER BY
    人口増加率 DESC,
    p.PF_CODE ASC;