with tmp as (
    select
        l.PF_CODE as 都道府県コード	,
        r.PF_NAME as 都道府県名,
        sum(case when SURVEY_YEAR = 2015 then TOTAL_AMT end) as 総人口2015年,
        sum(case when SURVEY_YEAR = 2020 then TOTAL_AMT end) as 総人口2020年,
        round(cast(sum(case when SURVEY_YEAR = 2020 then TOTAL_AMT end) as real) / cast(sum(case when SURVEY_YEAR = 2015 then TOTAL_AMT end) as real)*100) as 人口増加率
    
    from
        POPU_TRANSITION as l
    left join
        PREFECTURE as r
    on
        l.PF_CODE = r.PF_CODE
    group by
        l.PF_CODE
    order by
        人口増加率 desc,
        都道府県コード asc
)
select 
    *
from
    tmp
where
    総人口2015年 < 総人口2020年