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
  AND po.TOTAL_AMT >= pop.TOTAL_AMT
ORDER BY 人口増加率 DESC , 都道府県コード ASC