SELECT
    `都道府県コード`,
    `都道府県名`,
    `総人口2015年`,
    `総人口2020年`,
    ROUND(CAST(`総人口2020年` AS REAL) / CAST(`総人口2015年` AS REAL) * 100) AS `人口増加率`
FROM (
    SELECT
        P.PF_CODE AS `都道府県コード`,
        P.PF_NAME AS `都道府県名`,
        (
            SELECT TOTAL_AMT
            FROM POPU_TRANSITION AS PT
            WHERE P.PF_CODE = PT.PF_CODE AND PT.SURVEY_YEAR = 2015
        ) AS `総人口2015年`,
        (
            SELECT TOTAL_AMT
            FROM POPU_TRANSITION AS PT
            WHERE P.PF_CODE = PT.PF_CODE AND PT.SURVEY_YEAR = 2020
        ) AS `総人口2020年`
        -- `総人口2015年` / `総人口2020年`
    FROM PREFECTURE AS P
)
ORDER BY  `人口増加率` DESC, `都道府県コード` ASC