SELECT po.PF_CODE AS '都道府県コード'
      ,pr.PF_NAME AS '都道府県名'
      ,pop.TOTAL_AMT AS '総人口2015年'
      ,po.TOTAL_AMT AS '総人口2020年'
      ,ROUND((CAST(po.TOTAL_AMT AS REAL)/CAST(pop.TOTAL_AMT AS REAL))*100,0) AS '人口増加率'

FROM POPU_TRANSITION AS po

LEFT JOIN PREFECTURE AS pr
  ON pr.PF_CODE = po.PF_CODE

LEFT JOIN POPU_TRANSITION AS pop
  ON pop.PF_CODE = po.PF_CODE
 AND pop.SURVEY_YEAR = 2015

WHERE po.SURVEY_YEAR = 2020

GROUP BY po.PF_CODE , pr.PF_NAME
  AND pop.TOTAL_AMT >= po.TOTAL_AMT

ORDER BY 人口増加率 DESC , po.PF_CODE ASC