select
	P.PF_CODE as 都道府県コード,
	P.PF_NAME as 都道府県名,
	P15.TOTAL_AMT as 総人口2015年,
	P20.TOTAL_AMT as 総人口2020年,
	round((cast(P20.TOTAL_AMT as real) / cast(P15.TOTAL_AMT as real)) * 100,0) as 人口増加率
from
	PREFECTURE P
inner join
	(select * from POPU_TRANSITION where SURVEY_YEAR = 2015) as P15
on
	P.PF_CODE = P15.PF_CODE
inner join
	(select * from POPU_TRANSITION where SURVEY_YEAR = 2020) as P20
on
	P.PF_CODE = P20.PF_CODE
where
	人口増加率 > 100
order by
	人口増加率 desc, 都道府県コード asc