with a as (select pf_code x,pf_name y,total_amt z,survey_year w from popu_transition natural join prefecture)
select b.x 都道府県コード,b.y 都道府県名,p 総人口2015年,q 総人口2020年,round(100.0*q/p) 人口増加率
from (select x,y,z p from a where w=2015) b join (select x,y,z q from a where w=2020) c on b.x=c.x where q>p order by 5 desc,1;