SELECT PR.PF_CODE AS 都道府県コード
      ,PR.PF_NAME AS 都道府県名
      ,POP2015.TOTAL_AMT AS 総人口2015年
      ,POP2020.TOTAL_AMT AS 総人口2020年
      ,ROUND(POP2020.TOTAL_AMT / POP2015.TOTAL_AMT * 100)  AS 人口増加率
FROM PREFECTURE PR
LEFT OUTER JOIN (SELECT PF_CODE
                       ,1.0 * IFNULL(TOTAL_AMT, 0) AS TOTAL_AMT
                   FROM POPU_TRANSITION
                  WHERE SURVEY_YEAR = 2015) AS POP2015
  ON PR.PF_CODE = POP2015.PF_CODE
LEFT OUTER JOIN (SELECT PF_CODE
                       ,1.0 * IFNULL(TOTAL_AMT, 0) AS TOTAL_AMT
                   FROM POPU_TRANSITION
                  WHERE SURVEY_YEAR = 2020) AS POP2020
  ON PR.PF_CODE = POP2020.PF_CODE
WHERE POP2015.TOTAL_AMT < POP2020.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード