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