sql 求平均值，麻烦帮解决下

Question

这么一张表teamId（队伍id）   playerId（球员id） vId(比赛id)   date（比赛时间）   score(得分)
2                   1                   1            2009/2010           3
4                   2                   1            2009/2010           5
3                   5                   7            2009/2010           5
2                   1                   3            2008/2009           11
1                   4                   4            2009/2010           1.5
6                   5                   5            2009/2010           2
5                   1                   1            2009/2010           1
4                   1                   1            2009/2010           3
3                   1                   1            2009/2010           3我要查询指定teamId，playerId所有时间段的 score平均分比如 2009/2010的平均分
     2008/2009的平均分怎么写？麻烦大家帮帮忙

Answer 1

SELECT teamId，playerId,AVG(score) FROM TB GROUP BY teamId，playerId

Answer 2

SELECT date, teamId,playerId,AVG(score) FROM TB GROUP BY teamId，playerId,date

Answer 3

select teamId,playerId,avg(score) from @tb where date='2009/2010' 
and teamId='指定队伍'
and playerId='指定球员'
group by teamId , playerId 
?

Answer 4

select date,teamId,playerId,avg(score) as score
from tb
group by date,teamId,playerId

Answer 5

select teamId,playerId,date,avg(score) from @tb
where teamId='指定队伍'
and playerId='指定球员'
group by teamId , playerId ,date
???

Answer 6

select avg(score)
from 这么一张表
where teamId=xx and playerId = yyy

Answer 7

select
 date,teamId,playerId,avg(score) as score
from
 tb
group by
 date,teamId,playerId

Answer 8

select
 date,teamId,playerId,avg(score) as score
from
 tb
where teamId = 指定值 and playerId = 指定值
group by
 date,teamId,playerId

Answer 9

select teamId,playerId,date,avg(score) from tb
where teamId='队伍'and playerId='球员'
group by teamId,playerId,date