select PF.PF_CODE 都道府県コード, 
PF.PF_NAME 都道府県名, 
PT.TOTAL_AMT 総人口2015年, 
P2020.TOTAL_AMT 総人口2020年, 
ROUND(100*CAST(P2020.TOTAL_AMT as real)/CAST(PT.TOTAL_AMT as real)) 人口増加率
from POPU_TRANSITION as PT
    INNER join PREFECTURE as PF
    on PF.PF_CODE = PT.PF_CODE
    Inner join POPU_TRANSITION as P2020
    on P2020.SURVEY_YEAR = 2020
    and PF.PF_CODE = P2020.PF_CODE
where PT.SURVEY_YEAR = 2015 and P2020.TOTAL_AMT > PT.TOTAL_AMT
order by 人口増加率 DESC, 都道府県コード ASC;