select
    t1.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    total_amt_2015 as 総人口2015年,
    total_amt_2020 as 総人口2020年,
   round(cast(total_amt_2020 as REAL) / cast(total_amt_2015 as REAL) * 100) as 人口増加率
from (
    select
        pf_code,
        total_amt total_amt_2015
    from popu_transition
    where survey_year = 2015
) t1
left join (
    select
        pf_code,
        total_amt total_amt_2020
    from popu_transition
    where survey_year = 2020
) t2
on t1.pf_code = t2.pf_code
left join prefecture p
on t1.pf_code = p.pf_code
where cast(total_amt_2020 as REAL) / cast(total_amt_2015 as REAL) > 1
order by 人口増加率 desc, p.pf_code;