SELECT
    PT.PF_CODE AS '都道府県コード',
    PRF.PF_NAME AS '都道府県名',
    PT.TOTAL_AMT AS '総人口2015年',
    PT2020.TOTAL_AMT AS '総人口2020年',
    CAST(PT2020.TOTAL_AMT AS AA),
    CAST(PT.TOTAL_AMT AS BB),
    ROUND( 
        CAST(PT2020.TOTAL_AMT AS TZ) / CAST(PT.TOTAL_AMT AS TZ) * 100
    ) AS '人口増加率'
FROM
    POPU_TRANSITION AS PT
    INNER JOIN PREFECTURE AS PRF
        ON PRF.PF_CODE = PT.PF_CODE
    INNER JOIN POPU_TRANSITION AS PT2020
        ON PT2020.PF_CODE = PT.PF_CODE
        AND PT2020.SURVEY_YEAR = '2020'
WHERE
    PT.SURVEY_YEAR='2015'
    AND
    PT2020.TOTAL_AMT >= PT.TOTAL_AMT
ORDER BY
    '人口増加率' DESC,
    '都道府県コード' ASC
;