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