Menu

2009 Top Beginner Teams

Congratulations to these top Beginner teams. These are cumulative statistics for all 2009 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

Post Your Comments! You can now comment on these statistics. All comments are located at the bottom of this page.

*** 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

Problem with query SELECT quizzerstat09.first_name, quizzerstat09.last_name, (sum((teamppsstat09.i10c*10)+(teamppsstat09.i20c*20)+(teamppsstat09.i30c*30)-(teamppsstat09.i10e*5)-(teamppsstat09.i20e*10)-(teamppsstat09.i30e*15)))/sum(teamppsstat09.dgp) AS ppgi, sum(teamppsstat09.i10c+teamppsstat09.i20c+teamppsstat09.i30c+teamppsstat09.i10e+teamppsstat09.i20e+teamppsstat09.i30e) AS numquest, sum(teamppsstat09.dgp) AS numgames, COUNT(teamppsstat09.tourney_id) AS tourneys FROM quizzerstat09, tournaments09, teamstat09, teamppsstat09 WHERE tournaments09.tourney_id = teamppsstat09.tourney_id AND teamstat09.team_id = teamppsstat09.team_id AND teamstat09.quizzers[1] = quizzerstat09.quizzer_id AND tournaments09.type = 0 AND tournaments09.startdate >= '2009-01-01' AND teamppsstat09.dgp >= 3 GROUP BY quizzerstat09.first_name, quizzerstat09.last_name HAVING COUNT(quizzerstat09.tourney_id) >= 2 AND sum(teamppsstat09.i10c+teamppsstat09.i20c+teamppsstat09.i30c+teamppsstat09.i10e+teamppsstat09.i20e+teamppsstat09.i30e) > 29 ORDER BY ppgi DESC LIMIT 20
# Team PPG Interrupted Num Interrupted Questions Num Games Num Tourneys