select 
t1.PF_CODE  AS 都道府県コード
,t1.PF_NAME AS 都道府県名
,t2.TOTAL_AMT AS 総人口2015年
,t3.TOTAL_AMT AS 総人口2020年
,round(cast(t3.TOTAL_AMT as real) / cast(t2.TOTAL_AMT as real)*100,0) AS 人口増加率

from 
PREFECTURE t1
inner join POPU_TRANSITION t2
on t1.PF_CODE = t2.PF_CODE
and t2.SURVEY_YEAR = '2015'
inner join POPU_TRANSITION t3
on t1.PF_CODE = t3.PF_CODE
and t3.SURVEY_YEAR = '2020'



where 
t3.TOTAL_AMT - t2.TOTAL_AMT > 0


order by
人口増加率 desc
,都道府県コード