select
    pop.PF_CODE as 都道府県コード
    ,pre.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 = 2015 then TOTAL_AMT else 0 end) / sum(case when SURVEY_YEAR = 2020 then TOTAL_AMT else 0 end)) as 人口増加率
from POPU_TRANSITION pop
    left join PREFECTURE pre
        on pop.PF_CODE = pre.PF_CODE
group by 都道府県コード, 都道府県名
having 人口増加率 > 100
order by 人口増加率 desc, 都道府県コード