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 2015 then total_amt else 0 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
総人口2015年 < 総人口2020年
order by
人口増加率 desc, 都道府県コード asc