select P.PF_CODE as 都道府県コード,
    P.PF_NAME as 都道府県名,
    popu.TOTAL_AMT as 総人口2015年,
    popu2.TOTAL_AMT as 総人口2020年,
    ROUND(CAST(popu2.TOTAL_AMT as REAL)/CAST(popu.TOTAL_AMT as REAL)*100,0) as 人口増加率
from POPU_TRANSITION as popu
inner join POPU_TRANSITION as popu2 on popu.PF_CODE = popu2.PF_CODE and popu2.SURVEY_YEAR=2020
inner join PREFECTURE as P on  popu.PF_CODE = P.PF_CODE
where popu.SURVEY_YEAR = 2015
order by 人口増加率 desc, 都道府県コード asc;