select
    PF_CODE as 都道府県コード,
    PF_NAME as 都道府県名,
    TOTAL_AMT_2015 as 総人口2015年,
    TOTAL_AMT_2020 as 総人口2020年,
    round( TOTAL_AMT_2020 / cast(TOTAL_AMT_2015 as real) * 100 ) 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 ( TOTAL_AMT_2020 / cast(TOTAL_AMT_2015 as real) * 100 ) >= 100
order by 人口増加率 desc, 都道府県コード asc