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, 0) as 人口増加率
from
(select * from POPU_TRANSITION as PT INNER JOIN PREFECTURE as PR 
ON PT.PF_CODE = PR.PF_CODE
where SURVEY_YEAR = 2020) as PP
JOIN
(select * from POPU_TRANSITION as PT INNER JOIN PREFECTURE as PR 
ON PT.PF_CODE = PR.PF_CODE
where SURVEY_YEAR = 2015) as TT
ON PP.PF_CODE = TT.PF_CODE
order by 人口増加率 desc, PP.PF_CODE asc