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