with s1 as (select pf_code, total_amt from popu_transition where survey_year = 2015)
, s2 as (select pf_code, total_amt from popu_transition where survey_year = 2020)
select 
s1.pf_code as '都道府県コード'
, p.pf_name as '都道府県名'
, s1.total_amt as '総人口2015年'
, s2.total_amt as '総人口2020年'
, ROUND(100.0 * s2.total_amt / s1.total_amt) as '人口増加率'
from s1
join s2 on s1.pf_code = s2.pf_code
join prefecture as p on s1.pf_code = p.pf_code
where s1.total_amt < s2.total_amt
order by ROUND(100.0 * s2.total_amt / s1.total_amt) desc, p.pf_code