WITH t_2020 AS
  ( SELECT PF_CODE,
           TOTAL_AMT AS TOTAL_AMT_2020
   FROM POPU_TRANSITION
   WHERE SURVEY_YEAR = 2020 ),
     t_2015 AS
  ( SELECT PF_CODE,
           TOTAL_AMT AS TOTAL_AMT_2015
   FROM POPU_TRANSITION
   WHERE SURVEY_YEAR = 2015 )
SELECT t_2020.PF_CODE AS 都道府県コード,
       PREFECTURE.PF_NAME AS 都道府県名,
       TOTAL_AMT_2015 AS 総人口2015年,
       TOTAL_AMT_2020 AS 総人口2020年,
       round(100.0*TOTAL_AMT_2020/TOTAL_AMT_2015, 0) AS 人口増加率
FROM t_2020
LEFT JOIN t_2015 ON t_2020.PF_CODE = t_2015.PF_CODE
LEFT JOIN PREFECTURE ON t_2020.PF_CODE = PREFECTURE.PF_CODE
WHERE TOTAL_AMT_2020/TOTAL_AMT_2015 >= 1.0
ORDER BY 5 DESC,
         1 ASC