SELECT
    P.PF_CODE AS "都道府県コード",
    P.PF_NAME AS "都道府県名",
    PT_2015.TOTAL_AMT AS "総人口2015年",
    PT_2020.TOTAL_AMT AS "総人口2020年",
    ROUND(
        100*CAST(PT_2020.TOTAL_AMT AS REAL)/CAST(PT_2015.TOTAL_AMT AS REAL)
        
    ) AS "人口増加率"
FROM 
    PREFECTURE AS P
    INNER JOIN POPU_TRANSITION AS PT_2015
    ON P.PF_CODE = PT_2015.PF_CODE AND PT_2015.SURVEY_YEAR=2015
    
    INNER JOIN POPU_TRANSITION AS PT_2020
    ON P.PF_CODE = PT_2020.PF_CODE AND PT_2020.SURVEY_YEAR=2020
WHERE
    PT_2015.TOTAL_AMT<PT_2020.TOTAL_AMT
ORDER BY 
    "人口増加率" desc,
    P.PF_CODE
;