select
    *
from(
select
    a.PF_CODE as 都道府県コード,
    PF_NAME as 都道府県名,
    sum(
        case
            when survey_year = 2015 then total_amt
            else 0
        end 
    ) as 総人口2015年,
    sum(
        case
            when survey_year = 2020 then total_amt
            else 0
        end 
    ) as 総人口2020年,
    round(
        100.0 * 
        sum(
        case
            when survey_year = 2020 then total_amt
            else 0
        end 
    ) /     sum(
        case
            when survey_year = 2015 then total_amt
            else 0
        end 
    ) , 0) as 人口増加率
from
    POPU_TRANSITION as a
    inner join PREFECTURE as  b
    on a.pf_code = b.pf_code
where
    survey_year in (2015, 2020)
    --and 人口増加率 > 100
group by
    都道府県コード,
    都道府県名
order by
    人口増加率 desc,
    都道府県コード
)
where
    人口増加率 > 100