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