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