with TA2015 as (
select PF_CODE,TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2015
),
TA2020 as (
select PF_CODE,TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2020
)

select * from (
select a.PF_CODE as 都道府県コード
	,c.PF_NAME as 都道府県名
	,a.TOTAL_AMT as 総人口2015年
	,b.TOTAL_AMT as 総人口2020年
	,round(cast(b.TOTAL_AMT as real)/cast(a.TOTAL_AMT as real) * 100,0) as 人口増加率
from TA2015 as a
left outer join TA2020 as b
on a.PF_CODE = b.PF_CODE
left outer join PREFECTURE as c
on a.PF_CODE = c.PF_CODE
)
where 人口増加率 > 100
order by 5 desc,1
;