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)
    group by
        都道府県コード,
        都道府県名
    )
where
    総人口2020年 > 総人口2015年
order by
    人口増加率 desc,
    都道府県コード