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