So I realize this is 1) subjective and 2) not directly calculate-able, but who is the best Roux user who is also really good at 3BLD?
EDIT: I guess you could take everyone (known) who uses Roux from the top 200 or so and do a sum of ranks for the two events to be a little more objective about it.
Thanks, I've only ever seen him post BLD stuff so I didn't know he used Roux. But I feel like that more answers the question "Who's the best 3BLD-er that uses Roux" instead of "Who's the best Roux-er who's also good at 3BLD." Although its possible they have the same answer I guess.
Thanks, I've only ever seen him post BLD stuff so I didn't know he used Roux. But I feel like that more answers the question "Who's the best 3BLD-er that uses Roux" instead of "Who's the best Roux-er who's also good at 3BLD." Although its possible they have the same answer I guess.
I participated in 65 competitions and I have participated in 65 competitions with Sébastien, so I haven't been "alone" at a single competition (which is reasonable today, but wasn't some years ago... ).
So the question is: how many competitors have *only* participated in competitions where he participated?
I did this for every competitor with >50 competitions and for fellow competitors with >2 competitions:
Why these two restrictions? Particular the first one... wouldn't it be *more* impressive if someone had a large number of such "followers" despite having been to relatively few competitions?
Why these two restrictions? Particular the first one... wouldn't it be *more* impressive if someone had a large number of such "followers" despite having been to relatively few competitions?
The only reason is runtime.
I had the idea this afternoon and implemented it on the fly. It's too slow to calculate this for all competitors in a reasonable time. Maybe I will optimize it later...
[NOPARSE]select leader, count(*) minions
from
(select leader, minion, count(*) competitions
from (select distinct competitionId, personId leader from Results) a
join (select distinct competitionId, personId minion from Results) b
on a.competitionId = b.competitionId and leader != minion
group by leader, minion) tmp
natural join
(select personId minion, count(distinct competitionId) competitions from Results group by personId) tmp2
group by leader
order by minions desc
limit 100;[/NOPARSE]
What is the average number of competitions by a delegate in an year?
What are the top 10 maximum number of competitions delegated by a person in an year? (such that 1 person appears only once for his best result)
What is the average number of competitions by a delegate in an year?
What are the top 10 maximum number of competitions delegated by a person in an year? (such that 1 person appears only once for his best result)
Ok, here you go... the average number is 3.15 competitions per year.
It's not that easy to get the delegate data from the database since they are saved as real names incl. additional information. So there might be some mistakes in this list.