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