SELECT
    PRE.PF_CODE     AS "都道府県コード"
,   PRE.PF_NAME     AS "都道府県名"
,   PT1.TOTAL_AMT   AS "総人口2015年"
,   PT2.TOTAL_AMT   AS "総人口2020年"
,   ROUND(PT2.TOTAL_AMT / PT1.TOTAL_AMT * 100)  AS "人口増加率"
FROM
    PREFECTURE      PRE
    INNER JOIN
    POPU_TRANSITION PT1
    ON
    PRE.PF_CODE     = PT1.PF_CODE
    AND 2015        = PT1.SURVEY_YEAR
    INNER JOIN
    POPU_TRANSITION PT2
    ON
    PRE.PF_CODE     = PT1.PF_CODE
    AND 2020        = PT1.SURVEY_YEAR
WHERE
    PT1.TOTAL_AMT	< PT2.TOTAL_AMT
ORDER BY
    PT2.TOTAL_AMT / PT1.TOTAL_AMT ASC