select 
    t1.PF_CODE as 都道府県コード, 
    t1.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 PREFECTURE as t1
  inner join POPU_TRANSITION t2015
    on  t1.PF_CODE = t2015.PF_CODE 
    and t2015.SURVEY_YEAR = 2015
  inner join POPU_TRANSITION t2020
    on  t1.PF_CODE = t2020.PF_CODE 
    and t2020.SURVEY_YEAR = 2020
where 
    人口増加率 > 100
order by
    人口増加率 desc,
    t1.PF_CODE