SELECT 
*
FROM
(
SELECT
A.PF_CODE AS 都道府県コード,
PE.PF_NAME AS 都道府県名,
SUM(A.AMT_15) AS 総人口2015年,
SUM(A.AMT_20) AS 総人口2020年,
ROUND(CAST(SUM(A.AMT_20) AS REAL) / CAST(SUM(A.AMT_15) AS REAL) * 100,0) AS 人口増加率
FROM
(
SELECT
PF_CODE,
TOTAL_AMT AS AMT_15,
0 AS AMT_20
FROM POPU_TRANSITION
WHERE 
SURVEY_YEAR = 2015
GROUP BY
PF_CODE
UNION ALL
SELECT
PF_CODE,
0 AS AMT_15,
TOTAL_AMT AS AMT_20
FROM POPU_TRANSITION
WHERE 
SURVEY_YEAR = 2020
GROUP BY
PF_CODE
) AS A
LEFT JOIN PREFECTURE AS PE ON 
PE.PF_CODE = A.PF_CODE
GROUP BY
A.PF_CODE,
PE.PF_NAME
) AS S
WHERE 
S.総人口2015年 < 総人口2020年
ORDER BY
S.人口増加率 DESC,S.都道府県コード ASC