SELECT 
    PO.PF_CODE as 都道府県コード, PR.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))*100)) as 人口増加率
FROM
    POPU_TRANSITION AS PO
        JOIN
    PREFECTURE AS PR ON PO.PF_CODE = PR.PF_CODE
        JOIN
    POPU_TRANSITION AS PO2020 ON PO2020.PF_CODE = PO.PF_CODE
        AND PO2020.SURVEY_YEAR = 2020
WHERE
    PO.SURVEY_YEAR = 2015
ORDER BY 人口増加率 DESC , 都道府県コード ASC