Stefan
Member
Another little statistic, now that 2010 is over:
Code:
Year Competitions Persons Solves CompCountries PersCountries
-----------------------------------------------------------------
1982 1 19 56 1 19
2003 2 91 607 2 16
2004 12 205 2616 6 21
2005 24 548 8487 9 27
2006 33 844 16554 13 28
2007 53 1498 34635 20 48
2008 109 3019 86495 27 50
2009 169 5103 172162 38 66
2010 226 6306 260105 40 64
Code:
select year,
count(distinct competitionId),
count(distinct personId),
sum(if(value1>0,1,0)+if(value2>0,1,0)+if(value3>0,1,0)+if(value4>0,1,0)+if(value5>0,1,0)),
count(distinct Competitions.countryId),
count(distinct Results.countryId)
from Results, Competitions
where Competitions.id = competitionId
group by year
order by year
Last edited: