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
LEFT JOIN POPU_TRANSITION AS PT2015
    ON
        PT2015.PF_CODE = P.PF_CODE
        AND PT2015.SURVEY_YEAR = 2015
LEFT JOIN POPU_TRANSITION AS PT2020
    ON
        PT2020.PF_CODE = P.PF_CODE
        AND PT2020.SURVEY_YEAR = 2020
WHERE
    PT2015.TOTAL_AMT < PT2020.TOTAL_AMT
ORDER BY
    "人口増加率" DESC
    , P.PF_CODE ASC;