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
    where amt_2020 > amt_2015
    order by 人口増加率 desc, 都道府県コード
    ;