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 = 2015
      group by PF_CODE
    ) as t1 
    inner join (
      select PF_CODE, sum(TOTAL_AMT) as amt_2020
      from POPU_TRANSITION
      where SURVEY_YEAR = 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, "都道府県コード" asc
    ;