select 
PP.PF_CODE as 都道府県コード, 
PP.PF_NAME as 都道府県名,
TT.TOTAL_AMT as 総人口2015年 ,
PP.TOTAL_AMT as 総人口2020年,
ROUND(CAST(PP.TOTAL_AMT as double) /CAST(TT.TOTAL_AMT as double) * 100) as 人口増加率
from
(select PT.PF_CODE, PT.TOTAL_AMT from POPU_TRANSITION as PT INNER JOIN PREFECTURE as PR 
ON PT.PF_CODE = PR.PF_CODE
where SURVEY_YEAR = 2015) as TT
JOIN
(select PT.PF_CODE, PT.TOTAL_AMT, PR.PF_NAME from POPU_TRANSITION as PT INNER JOIN PREFECTURE as PR 
ON PT.PF_CODE = PR.PF_CODE
where SURVEY_YEAR = 2020) as PP
ON PP.PF_CODE = TT.PF_CODE
order by 人口増加率 desc, PP.PF_CODE asc