2010 Top Junior Teams
Congratulations to these top Junior teams. These are cumulative statistics for all 2010 tournaments which have been posted on this website. Must have participated in at least two posted tournaments to appear in these cumulative stats.
Top Beginner 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)
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 quizzerstat10.first_name, quizzerstat10.last_name, (sum((teamppsstat10.i10c*10)+(teamppsstat10.i20c*20)+(teamppsstat10.i30c*30)-(teamppsstat10.i10e*5)-(teamppsstat10.i20e*10)-(teamppsstat10.i30e*15)))/sum(teamppsstat10.dgp)
AS ppgi, sum(teamppsstat10.i10c+teamppsstat10.i20c+teamppsstat10.i30c+teamppsstat10.i10e+teamppsstat10.i20e+teamppsstat10.i30e) AS numquest, sum(teamppsstat10.dgp) AS numgames, COUNT(teamppsstat10.tourney_id) AS tourneys FROM quizzerstat10, tournaments10, teamstat10, teamppsstat10 WHERE tournaments10.tourney_id = teamppsstat10.tourney_id AND teamstat10.team_id = teamppsstat10.team_id AND teamstat10.quizzers = quizzerstat10.quizzer_id AND tournaments10.type = 1 AND tournaments10.startdate >= '2010-01-01' AND teamppsstat10.dgp >= 3 GROUP BY quizzerstat10.first_name, quizzerstat10.last_name HAVING COUNT(quizzerstat10.tourney_id) >= 2 AND sum(teamppsstat10.i10c+teamppsstat10.i20c+teamppsstat10.i30c+teamppsstat10.i10e+teamppsstat10.i20e+teamppsstat10.i30e) > 29 ORDER BY ppgi DESC LIMIT 20
||Num Interrupted Questions