SELECT
    P.PF_CODE AS "都道府県コード",
    P.PF_NAME AS "都道府県名",
    PT2015.TOTAL_AMT AS "総人口2015年",
    PT2020.TOTAL_AMT AS "総人口2020年",
    ROUND(CAST(PT2020.TOTAL_AMT AS REAL)/CAST(PT2015.TOTAL_AMT AS REAL),0) AS "人口増加率"
FROM
    PREFECTURE P
    INNER JOIN
    POPU_TRANSITION PT2015
    ON
        P.PF_CODE=PT2015.PF_CODE
        AND PT2015.SURVEY_YEAR=2015
    INNER JOIN
    POPU_TRANSITION PT2020
    ON
        P.PF_CODE=PT2020.PF_CODE
        AND PT2020.SURVEY_YEAR=2020
WHERE
    PT2020.TOTAL_AMT>PT2015.TOTAL_AMT
ORDER BY
    5 DESC, 1 ASC