select 
  t1.PF_CODE as 都道府県コード
  , t2.PF_NAME as 都道府県名
  , t3.TOTAL_AMT as 総人口2015年
  , t4.TOTAL_AMT as 総人口2020年
  , round(cast(t4.TOTAL_AMT as REAL) / cast(t3.TOTAL_AMT as REAL) * 100, 0) as 人口増加率
from
  -- 主テーブル
  (select distinct PF_CODE from POPU_TRANSITION) t1
  -- 都道府県
  left join PREFECTURE t2
    on t1.PF_CODE = t2.PF_CODE
  -- 総人口2015
  left join POPU_TRANSITION t3
    on t1.PF_CODE = t3.PF_CODE
    and t3.SURVEY_YEAR = '2015'
  -- 総人口2020
  left join POPU_TRANSITION t4
    on t1.PF_CODE = t4.PF_CODE
    and t4.SURVEY_YEAR = '2020'
where 
  t3.TOTAL_AMT < t4.TOTAL_AMT
order by
  人口増加率 desc, 都道府県コード