select f.PF_CODE as 都道府県コード,
PF_NAME as 都道府県名,
f.TOTAL_AMT as '総人口2015年',
t.TOTAL_AMT as '総人口2020年',
round(1.00 * f.TOTAL_AMT / t.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;