SELECT POP15.PF_CODE AS 都道府県コード
       ,PF_NAME AS 都道府県名
       ,POP15.TOTAL_AMT AS 総人口2015年
       ,POP20.TOTAL_AMT 総人口2020年
       ,ROUND(CAST(POP20.TOTAL_AMT AS REAL)/CAST(POP15.TOTAL_AMT AS REAL)*100) AS 人口増加率
  FROM (SELECT PF_CODE
               ,TOTAL_AMT
          FROM POPU_TRANSITION
         WHERE SURVEY_YEAR = 2015) AS POP15
  JOIN (SELECT PF_CODE
               ,TOTAL_AMT
          FROM POPU_TRANSITION
         WHERE SURVEY_YEAR = 2020) AS POP20
     ON POP15.PF_CODE = POP20.PF_CODE
  JOIN PREFECTURE AS PRE
    ON POP15.PF_CODE = PRE.PF_CODE
  WHERE POP15.TOTAL_AMT < POP20.TOTAL_AMT
 ORDER BY 人口増加率 DESC,都道府県コード