select
 sub1.PF_CODE as '都道府県コード'
,pr.PF_NAME as '都道府県名'
,sub1.TOTAL_AMT as '総人口2015年'
,sub2.TOTAL_AMT as '総人口2020年'
,round(cast(sub2.TOTAL_AMT as REAL) / cast(sub1.TOTAL_AMT as REAL) * 100) as '人口増加率'
from 
(select PF_CODE,TOTAL_AMT
    from
 POPU_TRANSITION
    where SURVEY_YEAR = 2015 ) sub1
inner join 
(select PF_CODE,TOTAL_AMT
    from
 POPU_TRANSITION
    where SURVEY_YEAR = 2020 ) sub2
on sub1.PF_CODE = sub2.PF_CODE and
 sub2.TOTAL_AMT > sub1.TOTAL_AMT
inner join PREFECTURE pr
on sub1.PF_CODE = pr.PF_CODE
order by 人口増加率 desc,sub1.PF_CODE