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