select
    POP_MAIN.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    POP_MAIN.TOTAL_AMT as 総人口2015年,
    POP_JOIN.TOTAL_AMT as 総人口2020年,
    round(
        cast(POP_JOIN.TOTAL_AMT as real) / cast(POP_MAIN.TOTAL_AMT as real) * 100
    ) as 人口増加率
from
    POPU_TRANSITION as POP_MAIN
    inner join
        PREFECTURE
        using(PF_CODE)
    inner join
        POPU_TRANSITION as POP_JOIN
        on
            POP_MAIN.PF_CODE = POP_JOIN.PF_CODE
            and POP_JOIN.SURVEY_YEAR = 2020
where
    POP_MAIN.SURVEY_YEAR = 2015
    and 総人口2020年 > 総人口2015年
order by
    人口増加率 desc,
    都道府県コード asc ;