select
  P.PF_CODE as 都道府県コード
  , PF_NAME as 都道府県名
  , PT2015.TOTAL_AMT as 総人口2015年
  , PT2020.TOTAL_AMT as 総人口2020年
  , round((cast(PT2020.TOTAL_AMT as real) / cast(PT2015.TOTAL_AMT as real)) * 100 , 0)  as 人口増加率
from
  (select PF_CODE, TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR = 2015) PT2015
  left join 
    (select PF_CODE, TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR = 2020) PT2020
    on PT2015.PF_CODE = PT2020.PF_CODE
  left join
    PREFECTURE P
    on PT2015.PF_CODE = P.PF_CODE
order by 人口増加率 desc, 都道府県コード
;