select
  PREFECTURE.PF_CODE AS 都道府県コード,
  PREFECTURE.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) AS 人口増加率
from
  (
    select
      PF_CODE,
      TOTAL_AMT
    from
      POPU_TRANSITION
    where
      SURVEY_YEAR = 2015
  ) AS PT_2015
inner join (
             select
              PF_CODE,
              TOTAL_AMT
            from
              POPU_TRANSITION
            where
              SURVEY_YEAR = 2020
           ) AS PT_2020
  on PT_2015.PF_CODE = PT_2020.PF_CODE
inner join PREFECTURE
  on PT_2015.PF_CODE = PREFECTURE.PF_CODE
order by
  人口増加率 desc,
  PREFECTURE.PF_CODE asc