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
    ORDER BY  人口増加率 DESC
             ,都道府県コード