select f.PF_CODE as 都道府県コード,
PF_NAME as 都道府県名,
f.TOTAL_AMT as '総人口2015年',
t.TOTAL_AMT as '総人口2020年',
round(1.00 * t.TOTAL_AMT / f.TOTAL_AMT * 100,0) as 人口増加率
from POPU_TRANSITION f
inner join POPU_TRANSITION t
on t.PF_CODE = f.PF_CODE
inner join PREFECTURE p
on p.PF_CODE = f.PF_CODE
where f.SURVEY_YEAR = 2015
and t.SURVEY_YEAR = 2020
and f.TOTAL_AMT < t.TOTAL_AMT
order by 人口増加率 desc, 都道府県コード asc;