SELECT
    PREFECTURE.PF_CODE AS '都道府県コード'
    , PREFECTURE.PF_NAME AS '都道府県名'
    , pop2015.TOTAL_AMT AS '総人口2015年'
    , pop2020.TOTAL_AMT AS '総人口2020年'
    , round(cast(pop2020.TOTAL_AMT AS real) / pop2015.TOTAL_AMT * 100) AS '人口増加率'
FROM
    PREFECTURE
    INNER JOIN
        (
            SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015
        ) pop2015 
        USING(PF_CODE)
    INNER JOIN
        (
            SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020
        ) pop2020
        USING(PF_CODE)
WHERE
    pop2015.TOTAL_AMT < pop2020.TOTAL_AMT
ORDER BY
    人口増加率 DESC
    , 都道府県コード
;