select 
    t2015.PF_CODE as 都道府県コード, 
    m.PF_NAME as 都道府県名,
    t2015.TOTAL_AMT as 総人口2015,
    t2020.TOTAL_AMT as 総人口2020,
    round(cast(t2020.TOTAL_AMT as real)  * 100 / cast(t2015.TOTAL_AMT as real)) as 人口増加率
from POPU_TRANSITION as t2015
  inner join POPU_TRANSITION t2020
    on  t2020.PF_CODE = t2015.PF_CODE 
    and t2020.SURVEY_YEAR = 2020
  inner join PREFECTURE m
    on  t2015.PF_CODE = m.PF_CODE 
where 
    t2015.SURVEY_YEAR = 2015 and
    t2020.TOTAL_AMT > t2015.TOTAL_AMT
order by
    人口増加率 desc,
    t2015.PF_CODE;