select
    distinct a.PF_CODE as 都道府県コード,
    PRE.PF_NAME as 都道府県名,
    a.TOTAL_AMT as 総人口2015年,
    b.TOTAL_AMT as 総人口2020年,
    round(cast(b.TOTAL_AMT*100 as real)/cast(a.TOTAL_AMT as real),0) as 人口増加率
from POPU_TRANSITION as a
    inner join PREFECTURE as PRE on a.PF_CODE=PRE.PF_CODE
    inner join POPU_TRANSITION as b on b.PF_CODE=a.PF_CODE and b.SURVEY_YEAR=2020
where a.SURVEY_YEAR=2015
order by 人口増加率 desc,都道府県コード asc