with a as (
select
  pf_code,
  case when survey_year = 2015 then total_amt end as total_2015,
  case when survey_year = 2020 then total_amt end as total_2020
from popu_transition
where total_2015 is not null or total_2020 is not null
),
b as (
select pf_code, max(total_2015) as total_2015, max(total_2020) as total_2020
from a
group by 1
)
select pf_code as '都道府県コード', pf_name as '都道府県名', total_2015 as '総人口2015年', total_2020 as '総人口2020年', round(total_2020*100.0/total_2015) as '人口増加率'
from b left outer join prefecture using(pf_code) where total_2015<total_2020 order by 5 desc, 1 asc