SELECT
    POP.PF_CODE AS `都道府県コード`,
    PRE.PF_NAME AS `都道府県名`,
    POP2015.TOTAL_AMT AS `総人口2015年`,
    POP2020.TOTAL_AMT AS `総人口2020年`,
    round(POP2020.TOTAL_AMT*100.0 / POP2015.TOTAL_AMT) AS `人口増加率`
FROM
    `POPU_TRANSITION`
        AS POP
LEFT OUTER JOIN
    `PREFECTURE`
        AS PRE
        ON PRE.PF_CODE = POP.PF_CODE
LEFT OUTER JOIN
    `POPU_TRANSITION`
        AS POP2015
        ON POP2015.SURVEY_YEAR = 2015
            AND POP2015.PF_CODE = POP.PF_CODE
LEFT OUTER JOIN
    `POPU_TRANSITION`
        AS POP2020
        ON POP2020.SURVEY_YEAR = 2020
            AND POP2020.PF_CODE = POP.PF_CODE
WHERE `人口増加率` > 100
GROUP BY POP.PF_CODE
ORDER BY
    `人口増加率` DESC,
    cast(`都道府県コード` AS INTEGER) ASC
;