2011 Top Beginner Teams
Congratulations to these top Beginner teams. These are cumulative statistics for all 2011 tournaments which have been posted on this website. Must have participated in at least two posted tournaments to appear in these cumulative stats.
Top Junior Teams Top Int Sr Teams Top Exp Sr Teams
*** If a team's district information is incorrect, it is because they quizzed as much in other districts' posted tournaments as in their own. *** |
Best Average Points Per Game (PPG)
| # |
Team |
Avg PPG |
Num Games |
Num Tourneys |
Best Average Points Per Game Interrupted (average points per game earned through interruptions by this team up to the point the game was locked)
* minimum of 30 questions interrupted
| # |
Team |
PPG Interrupted |
Num Interrupted Questions |
Num Games |
Num Tourneys |
Problem with query SELECT quizzerstat11.first_name, quizzerstat11.last_name, (sum((teamppsstat11.i10c*10)+(teamppsstat11.i20c*20)+(teamppsstat11.i30c*30)-(teamppsstat11.i10e*5)-(teamppsstat11.i20e*10)-(teamppsstat11.i30e*15)))/sum(teamppsstat11.dgp)
AS ppgi, sum(teamppsstat11.i10c+teamppsstat11.i20c+teamppsstat11.i30c+teamppsstat11.i10e+teamppsstat11.i20e+teamppsstat11.i30e) AS numquest, sum(teamppsstat11.dgp) AS numgames, COUNT(teamppsstat11.tourney_id) AS tourneys FROM quizzerstat11, tournaments11, teamstat11, teamppsstat11 WHERE tournaments11.tourney_id = teamppsstat11.tourney_id AND teamstat11.team_id = teamppsstat11.team_id AND teamstat11.quizzers[1] = quizzerstat11.quizzer_id AND tournaments11.type = 0 AND tournaments11.startdate >= '2011-01-01' AND teamppsstat11.dgp >= 3 GROUP BY quizzerstat11.first_name, quizzerstat11.last_name HAVING COUNT(quizzerstat11.tourney_id) >= 2 AND sum(teamppsstat11.i10c+teamppsstat11.i20c+teamppsstat11.i30c+teamppsstat11.i10e+teamppsstat11.i20e+teamppsstat11.i30e) > 29 ORDER BY ppgi DESC LIMIT 20