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