with temp1 as (
              select
                  t1.PF_CODE
                  ,t2.PF_NAME
                  ,cast(t1.TOTAL_AMT as real) as TOTAL_AMT_2015
              from
                  POPU_TRANSITION t1
              inner join
                  PREFECTURE t2 on t1.PF_CODE = t2.PF_CODE
              where
                  t1.SURVEY_YEAR = 2015
              ),temp2 as (
                          select
                            t1.PF_CODE
                            ,t2.PF_NAME
                            ,cast(t1.TOTAL_AMT as real) as TOTAL_AMT_2020
                          from
                              POPU_TRANSITION t1
                          inner join
                              PREFECTURE t2 on t1.PF_CODE = t2.PF_CODE
                          where
                              t1.SURVEY_YEAR = 2020
                            )
select
    t1.PF_CODE as 都道府県コード
    ,t1.PF_NAME as 都道府県名
    ,t1.TOTAL_AMT_2015 as 総人口2015年
    ,t2.TOTAL_AMT_2020 as 総人口2020年
    ,round((t2.TOTAL_AMT_2020 / t1.TOTAL_AMT_2015) * 100,0)  as 人口増加率
from
    temp1 t1
inner join
    temp2 t2 on t1.PF_CODE = t2.PF_CODE
where
    t1.TOTAL_AMT_2015 <  t2.TOTAL_AMT_2020
order by
    人口増加率 desc
    ,都道府県コード