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