select 
PF_CODE as 都道府県コード
,PF_NAME as 都道府県名
,T15.TOTAL_AMT as 総人口2015年
,T20.TOTAL_AMT as 総人口2020年
,round(1.0*T20.TOTAL_AMT/T15.TOTAL_AMT*100) as 人口増加率
from PREFECTURE
inner join (select * from POPU_TRANSITION where SURVEY_YEAR = 2015) T15
using(PF_CODE)
inner join (select * from POPU_TRANSITION where SURVEY_YEAR = 2020) T20
using(PF_CODE)
where 1.0*T20.TOTAL_AMT/T15.TOTAL_AMT*100>100
order by 人口増加率 desc,
都道府県コード