select pp1.pf_code as 都道府県コード, pf_name as 都道府県名,
pp1.total_amt as 総人口2015年, pp2.total_amt as 総人口2020年,
round(pp2.total_amt*100.0/pp1.total_amt) as 人口増加率
from popu_transition as pp1
join popu_transition as pp2
on pp1.pf_code = pp2.pf_code
join prefecture
on pp1.pf_code = prefecture.pf_code
where pp1.survey_year = 2015 and pp2.survey_year = 2020
order by 人口増加率 desc, cast(pp1.pf_code as decimal) asc;