select
 pf.pf_code as "都道府県コード"
 , pf.pf_name as "都道府県名"
 , fif.total_amt as "総人口2015年"
 , twe.total_amt as "総人口2020年"
 , round( cast(twe.total_amt as real) / cast(fif.total_amt as real) * 100 ) as "人口増加率"
from 
(select
 pf_code
 , total_amt
from
 popu_transition
where
 survey_year = 2015) fif
inner join (
    select
     pf_code
     , total_amt
    from
     popu_transition
    where
     survey_year = 2020
    ) twe
on fif.pf_code = twe.pf_code
and fif.total_amt < twe.total_amt
inner join prefecture pf
on fif.pf_code = pf.pf_code
order by
 round( cast(twe.total_amt as real) / cast(fif.total_amt as real) * 100 ) desc
 , pf.pf_code asc