select
t1.PF_CODE as 都道府県コード,
PF_NAME as 都道府県名,
amt_2015 as 総人口2015年,
amt_2020 as 総人口2020年,
round(cast(amt_2020 as real) / cast(amt_2015 as real) * 100) as 人口増加率
from (
  select PF_CODE, sum(TOTAL_AMT) as amt_2015
  from POPU_TRANSITION
  where SURVEY_YEAR in (2015)
  group by PF_CODE
) as t1 
inner join (
  select PF_CODE, sum(TOTAL_AMT) as amt_2020
  from POPU_TRANSITION
  where SURVEY_YEAR in (2020)
  group by PF_CODE
) as t2
on t1.PF_CODE = t2.PF_CODE
inner join PREFECTURE t3
on t2.PF_CODE = t3.PF_CODE
order by 人口増加率 desc, 都道府県コード
;