SELECT
    PR.PF_CODE AS "都道府県コード",
    PR.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, 0) AS "人口増加率"
FROM PREFECTURE PR
    LEFT OUTER JOIN POPU_TRANSITION PT2015
    ON  PR.PF_CODE = PT2015.PF_CODE
    AND PT2015.SURVEY_YEAR = 2015
    LEFT OUTER JOIN POPU_TRANSITION PT2020
    ON  PR.PF_CODE = PT2020.PF_CODE
    AND PT2020.SURVEY_YEAR = 2020
ORDER BY
    5 DESC, 1