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