SELECT
  POPU_TRANSITION.PF_CODE AS '都道府県コード',
  PREFECTURE.PF_NAME AS '都道府県名',
  MAX(
      CASE 
        WHEN SURVEY_YEAR = 2015 
          THEN TOTAL_AMT 
        ELSE NULL 
      END
  ) AS '総人口2015年',
  MAX(
      CASE 
        WHEN SURVEY_YEAR = 2020 
          THEN TOTAL_AMT 
        ELSE NULL 
      END
  ) AS '総人口2020年',
  (
  ROUND(
      cast(
        MAX(
          CASE 
            WHEN SURVEY_YEAR = 2020 
              THEN TOTAL_AMT 
            ELSE NULL 
          END
        ) 
      AS REAL)
      / 
      MAX(
          CASE 
            WHEN SURVEY_YEAR = 2015 
              THEN TOTAL_AMT 
            ELSE NULL 
          END
      ) * 100
  )
  ) AS '人口増加率'
FROM POPU_TRANSITION
  JOIN PREFECTURE
    ON POPU_TRANSITION.PF_CODE = PREFECTURE.PF_CODE
WHERE
  SURVEY_YEAR = 2015
  OR SURVEY_YEAR = 2020
GROUP BY
  POPU_TRANSITION.PF_CODE
HAVING
  総人口2015年 < 総人口2020年
ORDER BY
  人口増加率 DESC, 
  POPU_TRANSITION.PF_CODE ASC
;