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