SELECT
    PO2015.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    PO2015.TOTAL_AMT as 総人口2015年,
    PO2020.TOTAL_AMT as 総人口2020年,
    ROUND(CAST(PO2020.TOTAL_AMT as REAL)/CAST(PO2015.TOTAL_AMT as REAL) * 100) as 人口増加率
FROM
    POPU_TRANSITION as PO2015
    INNER JOIN PREFECTURE as PR
    ON PO2015.PF_CODE = PR.PF_CODE
    
    INNER JOIN POPU_TRANSITION AS PO2020
    ON PO2020.PF_CODE = PO2015.PF_CODE
    AND PO2020.SURVEY_YEAR = 2020
WHERE
    PO2015.SURVEY_YEAR = 2015
    AND PO2020.TOTAL_AMT > PO2015.TOTAL_AMT

ORDER BY
    人口増加率 DESC,
    都道府県コード ASC
;