SELECT 
    PF.PF_CODE as "都道府県コード",
    PF.PF_NAME as "都道府県名",
    PO.TOTAL_AMT as "総人口2015年",
    PO2020.TOTAL_AMT as "総人口2020年",
    ROUND(CAST(PO2020.TOTAL_AMT as REAL)/CAST(PO.TOTAL_AMT as REAL), 2)*100 as "人口増加率"
FROM
    -- 2015年のデータのみ抽出
    POPU_TRANSITION as PO
    INNER JOIN PREFECTURE AS PF ON PF.PF_CODE=PO.PF_CODE
    -- PO から PO2020を作成して内部結合
    INNER JOIN POPU_TRANSITION as PO2020 ON PO2020.PF_CODE=PO.PF_CODE AND PO2020.SURVEY_YEAR=2020
WHERE
    PO.SURVEY_YEAR=2015
    -- 人口が増加した都道府県だけ抽出したいので
    AND PO2020.TOTAL_AMT >= PO.TOTAL_AMT
ORDER BY
    "人口増加率" DESC,
    "都道府県コード" ASC;