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