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