select
s20.PF_CODE as 都道府県コード,
p.PF_NAME as 都道府県名,
s15.TOTAL_AMT  as  総人口2015年 , 
s20.TOTAL_AMT as 総人口2020年,
round(  cast(s20.TOTAL_AMT as float)  / cast( s15.TOTAL_AMT as float) *100, 0  ) as 人口増加率
from 
(
    select * from POPU_TRANSITION where SURVEY_YEAR = 2020 
) as s20
join
(
    select * from POPU_TRANSITION where SURVEY_YEAR = 2015 
) as s15
on s20.PF_CODE = s15.PF_CODE

join PREFECTURE as p on s20.PF_CODE = p.PF_CODE
where s20.TOTAL_AMT > s15.TOTAL_AMT 
order by 人口増加率 desc
;