select pre.PF_CODE as 都道府県コード,
       pre.PF_NAME as 都道府県名,
       pop_2015.TOTAL_AMT as 総人口2015年,
       pop_2020.TOTAL_AMT as 総人口2020年,
       round( ( cast((pop_2020.TOTAL_AMT - pop_2015.TOTAL_AMT) as REAL) ) / ( cast(pop_2020.TOTAL_AMT as REAL) ) * 100 ) + 100 as 人口増加率
from PREFECTURE as pre
    inner join POPU_TRANSITION as pop_2015
        on pre.PF_CODE = pop_2015.PF_CODE
        and pop_2015.SURVEY_YEAR = 2015
    inner join POPU_TRANSITION as pop_2020
        on pre.PF_CODE = pop_2020.PF_CODE
        and pop_2020.SURVEY_YEAR = 2020
where pop_2020.TOTAL_AMT - pop_2015.TOTAL_AMT > 0
order by 人口増加率 desc,
         pre.PF_CODE asc