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) * 100) as "人口増加率"
FROM
    PREFECTURE as p
INNER JOIN
    POPU_TRANSITION as pt2015 ON pt2015.PF_CODE = p.PF_CODE AND pt2015.SURVEY_YEAR = 2015
INNER JOIN
    POPU_TRANSITION as pt2020 ON pt2020.PF_CODE = p.PF_CODE AND pt2020.SURVEY_YEAR = 2020
WHERE
    pt2020.TOTAL_AMT >= pt2015.TOTAL_AMT
ORDER BY
    "人口増加率" DESC,
    "都道府県コード" ASC