select
  pre.PF_CODE as '都道府県コード',
  pre.PF_NAME as '都道府県名',
  pt2015.TOTAL_AMT as '総人口2015年',
  pt2020.TOTAL_AMT as '総人口2020年',
  round(100 * cast(pt2020.TOTAL_AMT as REAL) / cast(pt2015.TOTAL_AMT as REAL)) as '人口増加率'
from
  PREFECTURE pre
join
  POPU_TRANSITION pt2015
on
  pre.PF_CODE = pt2015.PF_CODE
and
  pt2015.SURVEY_YEAR = 2015
join
  POPU_TRANSITION pt2020
on
  pre.PF_CODE = pt2020.PF_CODE
and
  pt2020.SURVEY_YEAR = 2020
where
  pt2020.TOTAL_AMT > pt2015.TOTAL_AMT
order by
  `人口増加率` desc,
  pre.PF_CODE
;