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(1.*SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END)/SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END)*100,0) AS 人口増加率
FROM
  POPU_TRANSITION INNER JOIN
  PREFECTURE ON
    PREFECTURE.PF_CODE = POPU_TRANSITION.PF_CODE
GROUP BY
  POPU_TRANSITION.PF_CODE
HAVING
  ROUND(1.*SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END)/SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END)*100,0) > 100
ORDER BY 
  ROUND(1.*SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END)/SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END)*100,0) DESC,
  POPU_TRANSITION.PF_CODE ASC