SELECT
  POPU_TRANSITION.PF_CODE AS 都道府県コード,
  PREFECTURE.PF_NAME AS 都道府県名,
  SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS 総人口2015年,
  SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS 総人口2020年,
  ROUND(CAST(SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS REAL)/CAST(SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS REAL)*100,0) AS 人口増加率
FROM
  POPU_TRANSITION INNER JOIN
  PREFECTURE ON
    PREFECTURE.PF_CODE = POPU_TRANSITION.PF_CODE
GROUP BY
  POPU_TRANSITION.PF_CODE
HAVING
  SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) > SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END)
ORDER BY 
  人口増加率 DESC,
  POPU_TRANSITION.PF_CODE ASC