select 
	PF_CODE_2015 as 都道府県コード,
	PF_NAME as 都道府県名,
	TOTAL_AMT_2015 as 総人口2015年,
	TOTAL_AMT_2020 as 総人口2020年,
	TOTAL_AMT_glows as 人口増加率
From
	(SELECT
	    PF_CODE_2015,
	    TOTAL_AMT_2015,
	    TOTAL_AMT_2020,
	    round((CAST(TOTAL_AMT_2020 as REAL) / CAST(TOTAL_AMT_2015 as REAL)) * 100 ,0) as TOTAL_AMT_glows
	FROM
		(select 
			PF_CODE as PF_CODE_2015,
			TOTAL_AMT as TOTAL_AMT_2015
		from
			POPU_TRANSITION
		where 
			SURVEY_YEAR = '2015'
		) as d_2015
	inner join
		(select 
			PF_CODE as PF_CODE_2020,
			TOTAL_AMT as TOTAL_AMT_2020
		from
			POPU_TRANSITION
		where 
			SURVEY_YEAR = '2020'
		) as d_2020
	on
		PF_CODE_2015 = PF_CODE_2020 
	) as a
inner join
	PREFECTURE as b 
on
	a.PF_CODE_2015 = b.PF_CODE
where 
	TOTAL_AMT_glows > 100
order by 
	人口増加率 desc, 都道府県コード asc
;