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