select
    PREFECTURE.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    tbl2015.TOTAL_AMT2015 as 総人口2015年,
    tbl2020.TOTAL_AMT2020 as 総人口2020年,
     ROUND(
        (
            CAST(tbl2020.TOTAL_AMT2020 AS REAL) 
        )/ CAST(tbl2015.TOTAL_AMT2015 AS REAL) * 100 
    ) as 人口増加率
from
    PREFECTURE
    join (
        select
            pr.PF_CODE as 都道府県コード,
            pr.PF_NAME as 都道府県名,
            TOTAL_AMT as TOTAL_AMT2015
        from
            PREFECTURE as pr
            join POPU_TRANSITION as pt on pt.PF_CODE = pr.PF_CODE
        where
            SURVEY_YEAR = '2015'
    ) tbl2015 on PREFECTURE.PF_CODE = tbl2015.都道府県コード
    join (
        select
            pr.PF_CODE as 都道府県コード,
            pr.PF_NAME as 都道府県名,
            TOTAL_AMT as TOTAL_AMT2020
        from
            PREFECTURE as pr
            join POPU_TRANSITION as pt on pt.PF_CODE = pr.PF_CODE
        where
            SURVEY_YEAR = '2020'
    ) tbl2020 on PREFECTURE.PF_CODE = tbl2020.都道府県コード
where
    人口増加率 >= 100
order by
人口増加率 desc ,都道府県コード asc