with tbl1 as (
	select
		t.PF_CODE,
		m.PF_NAME,
		t.TOTAL_AMT
	from
		POPU_TRANSITION as t
	inner join
		PREFECTURE as "m" on t.PF_CODE = m.PF_CODE
	where
		SURVEY_YEAR = 2015
)
select
	t2020.PF_CODE as 都道府県コード,
	t2015.PF_NAME as 都道府県名,
	t2015.TOTAL_AMT as 総人口2015年,
	t2020.TOTAL_AMT as 総人口2020年,
	round(cast(t2020.TOTAL_AMT  as real) / cast(t2015.TOTAL_AMT as real),2) *100 as "人口増加率"
from
	POPU_TRANSITION as "t2020"
inner join
	tbl1 as "t2015" on t2020.PF_CODE = t2015.PF_CODE
where
	t2020.SURVEY_YEAR = 2020
	and
	t2015.TOTAL_AMT < t2020.TOTAL_AMT
order by
	"人口増加率" desc,
	"都道府県コード"
;