SELECT
    PRE.PF_CODE     AS "都道府県コード"
,   PRE.PF_NAME     AS "都道府県名"
,   PT1.TOTAL_AMT   AS "総人口2015年"
,   PT2.TOTAL_AMT   AS "総人口2020年"
,   ROUND((CAST(PT2.TOTAL_AMT AS REAL) *100) / CAST(PT1.TOTAL_AMT AS REAL) )  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     = PT2.PF_CODE
    AND 2020        = PT2.SURVEY_YEAR
WHERE
    PT1.TOTAL_AMT	< PT2.TOTAL_AMT
ORDER BY
    "人口増加率" DESC,"都道府県コード"