SELECT
    t1.PF_CODE AS 都道府県コード,
    p.PF_NAME AS 都道府県名,
    t1.TOTAL_AMT AS 総人口2015年,
    t2.TOTAL_AMT AS 総人口2020年,
    ROUND((1.0*t2.TOTAL_AMT /t1.TOTAL_AMT)*100,0) AS 人口増加率
FROM
    POPU_TRANSITION AS t1
JOIN
    POPU_TRANSITION AS t2
USING
    (PF_CODE)
JOIN
    PREFECTURE AS p
USING
    (PF_CODE)
WHERE
    t1.SURVEY_YEAR = 2015
    AND t2.SURVEY_YEAR = 2020
    AND t2.TOTAL_AMT > t1.TOTAL_AMT
ORDER BY
    ROUND((1.0*t2.TOTAL_AMT /t1.TOTAL_AMT)*100,0) DESC,
    PF_CODE ASC;