select
  pref.pf_code as 都道府県コード,
  pf_name as 都道府県名,
  total(popu2015.total_amt) as 総人口2015年,
  total(popu2020.total_amt) as 総人口2020年,
  round(cast(total(popu2020.total_amt) as real) / cast(total(popu2015.total_amt) as real) * 100) as 人口増加率
from prefecture as pref
left outer join (
  select
    pf_code,
    total_amt
  from popu_transition
  where survey_year = 2015
) as popu2015
on pref.pf_code = popu2015.pf_code
left outer join (
  select
    pf_code,
    total_amt
  from popu_transition
  where survey_year = 2020
) as popu2020
on pref.pf_code = popu2020.pf_code
group by
pref.pf_code, pf_name
having
人口増加率 > 100
order by
人口増加率 desc, 都道府県コード asc