SELECT POPU.PF_CODE AS '都道府県コード', PREFECTURE.PF_NAME AS '都道府県名',
    POPU.TOTAL_AMT AS '総人口2015年', popu_2020.TOTAL_AMT AS '総人口2020年',
    ROUND(CAST(popu_2020.TOTAL_AMT AS REAL)*100/CAST(POPU.TOTAL_AMT AS REAL)) AS '人口増加率'
  FROM POPU_TRANSITION AS POPU
  INNER JOIN PREFECTURE ON PREFECTURE.PF_CODE = POPU.PF_CODE
  INNER JOIN POPU_TRANSITION AS popu_2020 ON popu_2020.PF_CODE = POPU.PF_CODE AND popu_2020.SURVEY_YEAR = 2020
  WHERE POPU.SURVEY_YEAR = 2015 AND popu_2020.TOTAL_AMT > POPU.TOTAL_AMT
  ORDER BY 人口増加率 DESC, POPU.PF_CODE ASC