SELECT
    POP2015.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    POP2015.TOTAL_AMT AS 総人口2015,
    POP2020.TOTAL_AMT AS 総人口2020,
    ROUND(100.0*POP2020.TOTAL_AMT/POP2015.TOTAL_AMT) AS 人口増加率
FROM
    POPU_TRANSITION AS POP2015,
    (
        SELECT 
            PF_CODE, TOTAL_AMT
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2020
    ) AS POP2020,
    PREFECTURE
WHERE
    POP2015.PF_CODE = PREFECTURE.PF_CODE AND
    POP2015.PF_CODE = POP2020.PF_CODE AND
    POP2015.TOTAL_AMT < POP2020.TOTAL_AMT
ORDER BY
    人口増加率 DESC,
    POP2015.PF_CODE ASC;