SELECT p.PF_CODE AS 都道府県コード, PF_NAME AS 都道府県名, TOTAL_AMT_2015 AS 総人口2015年, TOTAL_AMT_2020 AS 総人口2020年, round((CAST(TOTAL_AMT_2020 AS REAL) / CAST(TOTAL_AMT_2015 AS REAL)), 2) * 100 AS 人口増加率
FROM (
    SELECT PF_CODE, SUM((CASE WHEN SURVEY_YEAR=2015 THEN TOTAL_AMT ELSE 0 END)) AS TOTAL_AMT_2015, SUM((CASE WHEN SURVEY_YEAR=2020 THEN TOTAL_AMT ELSE 0 END)) AS TOTAL_AMT_2020
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR in (2015, 2020)
    GROUP BY PF_CODE
) pt
JOIN PREFECTURE p ON(pt.PF_CODE=p.PF_CODE)
WHERE TOTAL_AMT_2020 > TOTAL_AMT_2015
ORDER BY 人口増加率 DESC, 都道府県コード