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