select
    t1.pf_code as '都道府県コード'
    ,p.pf_name as '都道府県名'
    ,t1.total_amt as '総人口2015年'
    ,t2.total_amt as '総人口2020年'
    ,round((cast(t2.total_amt as real) /cast(t1.total_amt as real) )* 100,0) as '人口増加率'
from
    popu_transition t1
cross join
    popu_transition t2
inner join prefecture p
    on t1.pf_code = p.pf_code
where
    t1.pf_code = t2.pf_code
    and t1.survey_year = 2015
    and t2.survey_year = 2020
    and t2.total_amt > t1.total_amt
order by
    人口増加率 desc
    ,都道府県コード asc