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
        P.PF_CODE = PT2015.PF_CODE
        AND PT2015.SURVEY_YEAR = 2015
LEFT JOIN POPU_TRANSITION AS PT2020
    ON
        P.PF_CODE = PT2020.PF_CODE
        AND PT2020.SURVEY_YEAR = 2020
WHERE
    PT2015.TOTAL_AMT < PT2020.TOTAL_AMT -- 人口が増加した都道府県を抽出
ORDER BY
    "人口増加率" DESC
    , P.PF_CODE ASC;