WITH Table1 AS (
SELECT PF_CODE,
    SUM(CASE WHEN SURVEY_YEAR=2015 THEN TOTAL_AMT ELSE 0 END) AS 総人口2015年,
    SUM(CASE WHEN SURVEY_YEAR=2020 THEN TOTAL_AMT ELSE 0 END) AS 総人口2020年
FROM POPU_TRANSITION
GROUP BY PF_CODE
)
SELECT T1.PF_CODE 都道府県コード,PF.PF_NAME 都道府県名,総人口2015年,総人口2020年,
    ROUND(CAST(総人口2020年 AS REAL)/CAST(総人口2015年 AS REAL)*100,0) AS 人口増加率
FROM Table1 AS T1 INNER JOIN PREFECTURE AS PF ON T1.PF_CODE=PF.PF_CODE
GROUP BY T1.PF_CODE
HAVING 人口増加率>100
ORDER BY 人口増加率 DESC,T1.PF_CODE