sql问题，单表MySQL数据库

Question

图中第一个是表，第二个是效果，请问这个sql怎么写？

Answer 1

SELECT
	 year as '年',
	 sum(CASE WHEN jidu = 1 THEN score ELSE 0 END) AS '第一季度',
	 sum(CASE WHEN jidu = 2 THEN score ELSE 0 END) AS '第二季度',
	 sum(CASE WHEN jidu = 3 THEN score ELSE 0 END) AS '第三季度',
	 sum(CASE WHEN jidu = 4 THEN score ELSE 0 END) AS '第四季度'
FROM test group by year