SELECT Name
,SUM(CASE Course WHEN '语文' THEN Score ELSE 0 END) AS [语文]
,SUM(CASE Course WHEN '数学' THEN Score ELSE 0 END) AS [数学]
,SUM(CASE Course WHEN '英语' THEN Score ELSE 0 END) AS [英语]
FROM Score
GROUP BY Name
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024