Sql Server 求平均值

统计所有班级各科的平均值：

select BanJi,AVG(A) as 语文, AVG(B) as 数学, AVG(C) as 英语
from oprScore
GROUP BY BanJi