select
  pref.pf_code as 都道府県コード,
  pf_name as 都道府県名,
  sum(case survey_year when 2015 then total_amt else 0 end) as 総人口2015年,  
  sum(case survey_year when 2020 then total_amt else 0 end) as 総人口2020年,
  round(cast(sum(case survey_year when 2020 then total_amt else 0 end) as real) / cast(sum(case survey_year when 2020 then 0 else total_amt end) as real) * 100) as 人口増加率
from popu_transition as popu
join prefecture as pref
on pref.pf_code = popu.pf_code
where
survey_year in (2015, 2020)
group by
pref.pf_code, pf_name
having
人口増加率 > 100
order by
人口増加率 desc, 都道府県コード asc;

--select * from popu_transition