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(round(TOTAL_AMT_2020 * 100,2 ) / round(TOTAL_AMT_2015,2) , 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
	left 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
left join
	PREFECTURE as b 
on
	a.PF_CODE_2015 = b.PF_CODE
where 
	TOTAL_AMT_glows > 100
order by 
	人口増加率 desc, 都道府県コード
;