select P.PF_CODE AS 都道府県コード
      ,P.PF_NAME AS 都道府県名
      ,PT_2015.TOTAL_AMT AS 総人口2015年
      ,PT_2020.TOTAL_AMT AS 総人口2020年
      ,ROUND(CAST(PT_2020.TOTAL_AMT as real) / CAST(PT_2015.TOTAL_AMT as real) * 100, 0) || '%' AS 人口増加率
  from PREFECTURE P
    inner join (
      select PF_CODE
            ,TOTAL_AMT
      from POPU_TRANSITION
      where SURVEY_YEAR = 2015
    ) AS PT_2015
    on PT_2015.PF_CODE = P.PF_CODE
    inner join (
      select PF_CODE
            ,TOTAL_AMT
      from POPU_TRANSITION
      where SURVEY_YEAR = 2020
    ) AS PT_2020
    on PT_2020.PF_CODE = P.PF_CODE
order by ROUND(CAST(PT_2020.TOTAL_AMT as real) / CAST(PT_2015.TOTAL_AMT as real) * 100, 0) desc, 都道府県コード
;