select PREFECTURE.PF_CODE as '都道府県コード',
       PREFECTURE.PF_NAME as '都道府県名',
       POP_2015.TOTAL_AMT as '総人口2015年',
       POP_2020.TOTAL_AMT as '総人口2020年',
       ROUND(cast(POP_2020.TOTAL_AMT as real)/cast(POP_2015.TOTAL_AMT as real)*100) as '人口増加率'
  from PREFECTURE 
  left outer join POPU_TRANSITION POP_2015
    on PREFECTURE.PF_CODE = POP_2015.PF_CODE
   and POP_2015.SURVEY_YEAR = 2015
  left outer join POPU_TRANSITION POP_2020
    on PREFECTURE.PF_CODE = POP_2020.PF_CODE
   and POP_2020.SURVEY_YEAR = 2020
 where POP_2015.TOTAL_AMT < POP_2020.TOTAL_AMT
 order by 5 desc, 1 asc