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