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