Odd WCA stats/ Stats request Thread

[Kit Clement]

Cool, thanks! Clock is not something I would have suspected to apply to older cubers.

Me neither, I'm actually just barely above average for the top 100.

 

[Torch]

Cool, thanks! Clock is not something I would have suspected to apply to older cubers.

Maybe this is because many of the top 100 clock results are from 2012 and earlier? I.e., they were younger when they set the times.

 

[Stefan]

Maybe this is because many of the top 100 clock results are from 2012 and earlier? I.e., they were younger when they set the times.

Oh wow, I'm *still* in the top 100 for clock with my average from April 2005. Almost ten years

Once I drop out, average age (as calculated by Sebastien) for clock average will drop by about 2 years.

 

[Torch]

Oh wow, I'm *still* in the top 100 for clock with my average from April 2005. Almost ten years

Once I drop out, average age (as calculated by Sebastien) for clock average will drop by about 2 years.

Shouldn't that be 2 months, not 2 years?

 

[Hssandwich]

Would it be possible to work out the fastest average and slowest single compared to each other. e.g. I am 90th in the world for skewb average and 266th for single.

 

[Stefan]

Shouldn't that be 2 months, not 2 years?

Oops. Thanks. I guess I overestimated my influence

Something else:

Spoiler: Difference onehanded minus regular 3x3

Using data from WCA_export599_20150210 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]personId[/TD][TD]onehanded[/TD][TD]regular[/TD][TD]onehanded-regular[/TD][/TR]
[TR][TD]Zhiqiang Hao (郝志强)[/TD][TD="align:right"]4:47.05[/TD][TD="align:right"]5:07.36[/TD][TD="align:right"]-20.31[/TD][/TR]
[TR][TD]Edward Calvo[/TD][TD="align:right"]55.05[/TD][TD="align:right"]58.37[/TD][TD="align:right"]-3.32[/TD][/TR]
[TR][TD]Yanquan Wen (温延泉)[/TD][TD="align:right"]25.01[/TD][TD="align:right"]28.20[/TD][TD="align:right"]-3.19[/TD][/TR]
[TR][TD]Pu Su (苏普)[/TD][TD="align:right"]18.28[/TD][TD="align:right"]18.86[/TD][TD="align:right"]-0.58[/TD][/TR]
[TR][TD]Neil Morales[/TD][TD="align:right"]9.30[/TD][TD="align:right"]9.84[/TD][TD="align:right"]-0.54[/TD][/TR]
[TR][TD]Chun Lin (林春)[/TD][TD="align:right"]15.52[/TD][TD="align:right"]16.02[/TD][TD="align:right"]-0.50[/TD][/TR]
[TR][TD]Chenxi Shan (单晨曦)[/TD][TD="align:right"]27.50[/TD][TD="align:right"]27.43[/TD][TD="align:right"]0.07[/TD][/TR]
[TR][TD]Fin Thiessen[/TD][TD="align:right"]17.81[/TD][TD="align:right"]17.47[/TD][TD="align:right"]0.34[/TD][/TR]
[TR][TD]Yaozong Liang (梁耀宗)[/TD][TD="align:right"]15.94[/TD][TD="align:right"]15.46[/TD][TD="align:right"]0.48[/TD][/TR]
[TR][TD]Andrew Brown[/TD][TD="align:right"]11.81[/TD][TD="align:right"]11.31[/TD][TD="align:right"]0.50[/TD][/TR]
[TR][TD]Zhiye Qian (钱志业)[/TD][TD="align:right"]14.71[/TD][TD="align:right"]14.18[/TD][TD="align:right"]0.53[/TD][/TR]
[TR][TD]Tinnapop Suparjak (ติณณภพ สุภาจักร์)[/TD][TD="align:right"]19.17[/TD][TD="align:right"]18.27[/TD][TD="align:right"]0.90[/TD][/TR]
[TR][TD]Bhargav Narasimhan[/TD][TD="align:right"]9.52[/TD][TD="align:right"]8.43[/TD][TD="align:right"]1.09[/TD][/TR]
[TR][TD]Sittinon Sukhaya (สิทธินนท์ สุขายะ)[/TD][TD="align:right"]12.34[/TD][TD="align:right"]11.18[/TD][TD="align:right"]1.16[/TD][/TR]
[TR][TD]Kevin Jeffry Nalvarte Yantas[/TD][TD="align:right"]13.73[/TD][TD="align:right"]12.52[/TD][TD="align:right"]1.21[/TD][/TR]
[TR][TD]Daniel Chung[/TD][TD="align:right"]14.56[/TD][TD="align:right"]13.25[/TD][TD="align:right"]1.31[/TD][/TR]
[TR][TD]Jang Jae-Hyouk[/TD][TD="align:right"]15.11[/TD][TD="align:right"]13.78[/TD][TD="align:right"]1.33[/TD][/TR]
[TR][TD]Anders Berggren[/TD][TD="align:right"]11.02[/TD][TD="align:right"]9.66[/TD][TD="align:right"]1.36[/TD][/TR]
[TR][TD]Ric Donati[/TD][TD="align:right"]11.94[/TD][TD="align:right"]10.56[/TD][TD="align:right"]1.38[/TD][/TR]
[TR][TD]Xuan Gong (龚轩)[/TD][TD="align:right"]14.37[/TD][TD="align:right"]12.89[/TD][TD="align:right"]1.48[/TD][/TR]
[TR][TD]Peiyan Li (利沛焰)[/TD][TD="align:right"]14.06[/TD][TD="align:right"]12.50[/TD][TD="align:right"]1.56[/TD][/TR]
[TR][TD]Velidi Venkata Jagan Mohana Murali Krishna[/TD][TD="align:right"]12.59[/TD][TD="align:right"]11.00[/TD][TD="align:right"]1.59[/TD][/TR]
[TR][TD]Zhe Jia (贾喆)[/TD][TD="align:right"]19.19[/TD][TD="align:right"]17.57[/TD][TD="align:right"]1.62[/TD][/TR]
[TR][TD]Baramee Pookcharoen (บารมี พุกเจริญ)[/TD][TD="align:right"]9.65[/TD][TD="align:right"]8.03[/TD][TD="align:right"]1.62[/TD][/TR]
[TR][TD]Sriram Govind[/TD][TD="align:right"]15.14[/TD][TD="align:right"]13.48[/TD][TD="align:right"]1.66[/TD][/TR]
[TR][TD]Yen-Ting Lin (林彥廷)[/TD][TD="align:right"]14.78[/TD][TD="align:right"]13.07[/TD][TD="align:right"]1.71[/TD][/TR]
[TR][TD]Piotr Alexandrowicz[/TD][TD="align:right"]11.19[/TD][TD="align:right"]9.47[/TD][TD="align:right"]1.72[/TD][/TR]
[TR][TD]Marco Vorländer[/TD][TD="align:right"]14.19[/TD][TD="align:right"]12.31[/TD][TD="align:right"]1.88[/TD][/TR]
[TR][TD]Gloryan Casimir Nursewan[/TD][TD="align:right"]11.91[/TD][TD="align:right"]10.02[/TD][TD="align:right"]1.89[/TD][/TR]
[TR][TD]Peter Hung[/TD][TD="align:right"]14.61[/TD][TD="align:right"]12.72[/TD][TD="align:right"]1.89[/TD][/TR]
[TR][TD]Alexey Polyashov[/TD][TD="align:right"]10.78[/TD][TD="align:right"]8.84[/TD][TD="align:right"]1.94[/TD][/TR]
[TR][TD]Sebastiano Tronto[/TD][TD="align:right"]11.88[/TD][TD="align:right"]9.90[/TD][TD="align:right"]1.98[/TD][/TR]
[TR][TD]Ridvan Song[/TD][TD="align:right"]32.53[/TD][TD="align:right"]30.53[/TD][TD="align:right"]2.00[/TD][/TR]
[TR][TD]Kunaal Parekh[/TD][TD="align:right"]14.19[/TD][TD="align:right"]12.17[/TD][TD="align:right"]2.02[/TD][/TR]
[TR][TD]Adesh Mehta[/TD][TD="align:right"]21.94[/TD][TD="align:right"]19.87[/TD][TD="align:right"]2.07[/TD][/TR]
[TR][TD]Fardin Bahadory Nejad (فردین بهادری نژاد)[/TD][TD="align:right"]11.18[/TD][TD="align:right"]9.08[/TD][TD="align:right"]2.10[/TD][/TR]
[TR][TD]Alexey Emelyanov[/TD][TD="align:right"]20.94[/TD][TD="align:right"]18.83[/TD][TD="align:right"]2.11[/TD][/TR]
[TR][TD]Aakash Josh[/TD][TD="align:right"]14.07[/TD][TD="align:right"]11.96[/TD][TD="align:right"]2.11[/TD][/TR]
[TR][TD]Xiaofeng Jiao (焦晓峰)[/TD][TD="align:right"]14.38[/TD][TD="align:right"]12.25[/TD][TD="align:right"]2.13[/TD][/TR]
[TR][TD]Antoine Cantin[/TD][TD="align:right"]8.75[/TD][TD="align:right"]6.50[/TD][TD="align:right"]2.25[/TD][/TR]
[TR][TD]Mohammad Reza Karimi (محمد رضا کریمی)[/TD][TD="align:right"]13.53[/TD][TD="align:right"]11.27[/TD][TD="align:right"]2.26[/TD][/TR]
[TR][TD]Tomohiro Tanno (丹野智博)[/TD][TD="align:right"]13.16[/TD][TD="align:right"]10.90[/TD][TD="align:right"]2.26[/TD][/TR]
[TR][TD]Wen-chung Tien (田文中)[/TD][TD="align:right"]15.39[/TD][TD="align:right"]13.12[/TD][TD="align:right"]2.27[/TD][/TR]
[TR][TD]Pinyao Wang (王品尧)[/TD][TD="align:right"]14.08[/TD][TD="align:right"]11.81[/TD][TD="align:right"]2.27[/TD][/TR]
[TR][TD]Pablo Grasböck[/TD][TD="align:right"]12.65[/TD][TD="align:right"]10.34[/TD][TD="align:right"]2.31[/TD][/TR]
[TR][TD]SeungYoon Hyeon[/TD][TD="align:right"]12.99[/TD][TD="align:right"]10.68[/TD][TD="align:right"]2.31[/TD][/TR]
[TR][TD]Piotr Tomczyk[/TD][TD="align:right"]10.68[/TD][TD="align:right"]8.34[/TD][TD="align:right"]2.34[/TD][/TR]
[TR][TD]Gabriel Dechichi Barbar[/TD][TD="align:right"]9.50[/TD][TD="align:right"]7.16[/TD][TD="align:right"]2.34[/TD][/TR]
[TR][TD]Ming Chen 2 (陈明)[/TD][TD="align:right"]16.22[/TD][TD="align:right"]13.88[/TD][TD="align:right"]2.34[/TD][/TR]
[TR][TD]Chris Dzoan[/TD][TD="align:right"]11.97[/TD][TD="align:right"]9.61[/TD][TD="align:right"]2.36[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]SELECT personId, onehanded 'onehanded[T]', regular 'regular[T]', onehanded-regular 'onehanded-regular[T]' FROM
(SELECT personId, best regular FROM RanksSingle WHERE eventId='333') a NATURAL JOIN
(SELECT personId, best onehanded FROM RanksSingle WHERE eventId='333oh') b
ORDER BY onehanded-regular
LIMIT 50[/NOPARSE]

 

[bubbagrub]

Would it be possible to work out the fastest average and slowest single compared to each other. e.g. I am 90th in the world for skewb average and 266th for single.

For 3x3, the biggest discrepancy is Kasoju Chandra Kanth who has a 13.36 single and a best average of 48.87.

Since you asked about Skewb, the biggest discrepancy there is Cody Brown who has a best single of 3.38 (68th in the world) and a best average of 25.86 (2131st in the world). Wow.

 

[vcuber13]

What percentage of competitors have gone to at least one competition per year since their first competition? In general, and by year of first competition, if possible.

 

[Stefan]

Is it forbidden to show here the actual top ten list for cubers older than 70 (3x3x3)?

Do you mean you have it and want to show it, or do you mean you'd like someone (like me) to show it? WCA now considers birthdaydate/age data private and not to be used for something like this. I myself am in fact personally forbidden to give away such data. But if some "outsider" like you (I mean, without access to our data) somehow managed to come up with such a list, perhaps because there's a facebook group where all the WCA seniors meet and exchange their data , I guess that might not be forbidden (except maybe by laws, which was one of the reasons for WCA to change its policy).

 

[ottozing]

http://www.worldcubeassociation.org/results/misc/sum_of_ranks/?regionId=&average=Average

Vincent Hartanto Utomo is 11th without a 7x7 mean, even though he could probably get a good enough mean to beat Antoine if he borrowed a cube from someone at a comp and practiced a bit.

Swag.

 

[bubbagrub]

What percentage of competitors have gone to at least one competition per year since their first competition? In general, and by year of first competition, if possible.

If we only look up to the end of 2014, and exclude 1982, I reckon:

[table="width: 500, class: grid"]
[tr]
[td]2003[/td]
[td]7.95%[/td]
[/tr]
[tr]
[td]2004[/td]
[td]4.59%[/td]
[/tr]
[tr]
[td]2005[/td]
[td]6.00%[/td]
[/tr]
[tr]
[td]2006[/td]
[td]6.21%[/td]
[/tr]
[tr]
[td]2007[/td]
[td]7.69%[/td]
[/tr]
[tr]
[td]2008[/td]
[td]5.98%[/td]
[/tr]
[tr]
[td]2009[/td]
[td]5.78%[/td]
[/tr]
[tr]
[td]2010[/td]
[td]7.30%[/td]
[/tr]
[tr]
[td]2011[/td]
[td]11.00%[/td]
[/tr]
[tr]
[td]2012[/td]
[td]18.97%[/td]
[/tr]
[tr]
[td]2013[/td]
[td]36.32%[/td]
[/tr]
[tr]
[td]2014[/td]
[td]100%[/td]
[/tr]
[/table]

Note that the 100% for 2014 is meaningless, since I only looked up to the end of 2014 -- it's just useful as a debug to help confirm the query I used worked. You could do the same thing including 2015, but obviously that would give much lower percentages since we're so early in the year.

Here's the query I used:

select AVG(s/t), y FROM (select y, SUM(ny=c) as s, count(*) as t from (select MIN(year) as y, 2015 - MIN(year) as ny, count(distinct year) as c, personID from Results, Competitions where Results.competitionID = Competitions.id and year < 2015 and year > 2000 group by personID) as t1 group by personID) as t2 group by y order by y asc;
​

 

[TDM]

I can't remember seeing this before: list of countries ordered by average number of people per competition?

 

[Stefan]

Spoiler: Countries by average number of competitors

Using data from WCA_export603_20150216 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]countryId[/TD][TD]avgCompetitors[/TD][TD]competitions[/TD][TD]minCompetitors[/TD][TD]maxCompetitors[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]116.3333[/TD][TD="align:right"]12[/TD][TD="align:right"]19[/TD][TD="align:right"]227[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]82.8750[/TD][TD="align:right"]8[/TD][TD="align:right"]18[/TD][TD="align:right"]193[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]82.8000[/TD][TD="align:right"]5[/TD][TD="align:right"]32[/TD][TD="align:right"]141[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]79.6667[/TD][TD="align:right"]3[/TD][TD="align:right"]71[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]77.1000[/TD][TD="align:right"]10[/TD][TD="align:right"]28[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]74.7097[/TD][TD="align:right"]93[/TD][TD="align:right"]34[/TD][TD="align:right"]285[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]73.1667[/TD][TD="align:right"]18[/TD][TD="align:right"]25[/TD][TD="align:right"]292[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]73.0889[/TD][TD="align:right"]90[/TD][TD="align:right"]15[/TD][TD="align:right"]254[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]72.6000[/TD][TD="align:right"]25[/TD][TD="align:right"]14[/TD][TD="align:right"]216[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]71.0000[/TD][TD="align:right"]3[/TD][TD="align:right"]33[/TD][TD="align:right"]94[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]70.3200[/TD][TD="align:right"]25[/TD][TD="align:right"]21[/TD][TD="align:right"]127[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]70.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]70[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]65.0658[/TD][TD="align:right"]76[/TD][TD="align:right"]13[/TD][TD="align:right"]327[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]64.5172[/TD][TD="align:right"]58[/TD][TD="align:right"]13[/TD][TD="align:right"]119[/TD][/TR]
[TR][TD]Uruguay[/TD][TD="align:right"]64.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]59[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]59.7751[/TD][TD="align:right"]209[/TD][TD="align:right"]3[/TD][TD="align:right"]236[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]57.1333[/TD][TD="align:right"]60[/TD][TD="align:right"]12[/TD][TD="align:right"]155[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]57.0952[/TD][TD="align:right"]21[/TD][TD="align:right"]16[/TD][TD="align:right"]195[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]54.7857[/TD][TD="align:right"]14[/TD][TD="align:right"]24[/TD][TD="align:right"]151[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]54.0000[/TD][TD="align:right"]25[/TD][TD="align:right"]18[/TD][TD="align:right"]115[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]53.7259[/TD][TD="align:right"]405[/TD][TD="align:right"]10[/TD][TD="align:right"]580[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]52.6923[/TD][TD="align:right"]39[/TD][TD="align:right"]12[/TD][TD="align:right"]120[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]52.5000[/TD][TD="align:right"]8[/TD][TD="align:right"]23[/TD][TD="align:right"]105[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]50.5652[/TD][TD="align:right"]23[/TD][TD="align:right"]16[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]48.1290[/TD][TD="align:right"]31[/TD][TD="align:right"]17[/TD][TD="align:right"]87[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]48.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]34[/TD][TD="align:right"]62[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]46.8750[/TD][TD="align:right"]8[/TD][TD="align:right"]10[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]46.7500[/TD][TD="align:right"]4[/TD][TD="align:right"]40[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]45.7830[/TD][TD="align:right"]106[/TD][TD="align:right"]12[/TD][TD="align:right"]206[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]45.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]19[/TD][TD="align:right"]71[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]44.3333[/TD][TD="align:right"]24[/TD][TD="align:right"]20[/TD][TD="align:right"]67[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]44.2000[/TD][TD="align:right"]10[/TD][TD="align:right"]19[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]44.1379[/TD][TD="align:right"]29[/TD][TD="align:right"]15[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]43.7561[/TD][TD="align:right"]41[/TD][TD="align:right"]7[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]43.2222[/TD][TD="align:right"]9[/TD][TD="align:right"]27[/TD][TD="align:right"]67[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]42.3393[/TD][TD="align:right"]56[/TD][TD="align:right"]9[/TD][TD="align:right"]152[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]42.0429[/TD][TD="align:right"]70[/TD][TD="align:right"]10[/TD][TD="align:right"]158[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]41.0000[/TD][TD="align:right"]7[/TD][TD="align:right"]28[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]40.8750[/TD][TD="align:right"]16[/TD][TD="align:right"]12[/TD][TD="align:right"]78[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]40.6000[/TD][TD="align:right"]5[/TD][TD="align:right"]26[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]39.6571[/TD][TD="align:right"]35[/TD][TD="align:right"]12[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]39.4222[/TD][TD="align:right"]45[/TD][TD="align:right"]13[/TD][TD="align:right"]147[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]39.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]28[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]38.5000[/TD][TD="align:right"]16[/TD][TD="align:right"]21[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]38.0000[/TD][TD="align:right"]6[/TD][TD="align:right"]20[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]37.7500[/TD][TD="align:right"]4[/TD][TD="align:right"]27[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]37.2683[/TD][TD="align:right"]41[/TD][TD="align:right"]9[/TD][TD="align:right"]78[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]37.0920[/TD][TD="align:right"]87[/TD][TD="align:right"]9[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD]Tunisia[/TD][TD="align:right"]37.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]37[/TD][TD="align:right"]37[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]35.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]35[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]35.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]35[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]34.2105[/TD][TD="align:right"]19[/TD][TD="align:right"]13[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]33.7656[/TD][TD="align:right"]64[/TD][TD="align:right"]16[/TD][TD="align:right"]78[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]33.3793[/TD][TD="align:right"]29[/TD][TD="align:right"]9[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]33.0000[/TD][TD="align:right"]33[/TD][TD="align:right"]12[/TD][TD="align:right"]269[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]32.0000[/TD][TD="align:right"]9[/TD][TD="align:right"]16[/TD][TD="align:right"]48[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]29.3333[/TD][TD="align:right"]12[/TD][TD="align:right"]17[/TD][TD="align:right"]47[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]23.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]23[/TD][TD="align:right"]23[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]22.5000[/TD][TD="align:right"]4[/TD][TD="align:right"]17[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]21.1667[/TD][TD="align:right"]12[/TD][TD="align:right"]9[/TD][TD="align:right"]40[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]20.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]15[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]19.6667[/TD][TD="align:right"]3[/TD][TD="align:right"]16[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]19.5833[/TD][TD="align:right"]24[/TD][TD="align:right"]11[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]19.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]19[/TD][TD="align:right"]19[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]18.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]13[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Andorra[/TD][TD="align:right"]17.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]17[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]15.9167[/TD][TD="align:right"]12[/TD][TD="align:right"]8[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]15.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]15[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]9.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]9[/TD][TD="align:right"]9[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]select countryId, avg(competitors) avgCompetitors, count(*) competitions, min(competitors) minCompetitors, max(competitors) maxCompetitors
from (select competitionId id, count(distinct personId) competitors from Results group by competitionId) tmp
natural join Competitions
group by countryId
order by avgCompetitors desc[/NOPARSE]

 

[TDM]

Countries by average number of competitors

Thanks. Interesting to see Hungary on top; I wouldn't have expected that.

 

[Stefan]

Thanks. Interesting to see Hungary on top; I wouldn't have expected that.

Yeah, and so far ahead of all other countries. Well, they have about one competition per year so it's quite concentrated.

 

[Stefan]

They also got many visitors. If I only count competitors that are citizens of the competition's country, Hungary is far less ahead:

Spoiler: Countries by average number of citizen competitors

Using data from WCA_export603_20150216 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]countryId[/TD][TD]avgCompetitors[/TD][TD]competitions[/TD][TD]minCompetitors[/TD][TD]maxCompetitors[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]83.5833[/TD][TD="align:right"]12[/TD][TD="align:right"]1[/TD][TD="align:right"]135[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]79.6667[/TD][TD="align:right"]3[/TD][TD="align:right"]71[/TD][TD="align:right"]92[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]76.6000[/TD][TD="align:right"]10[/TD][TD="align:right"]28[/TD][TD="align:right"]151[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]72.1333[/TD][TD="align:right"]90[/TD][TD="align:right"]15[/TD][TD="align:right"]250[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]70.6452[/TD][TD="align:right"]93[/TD][TD="align:right"]33[/TD][TD="align:right"]215[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]68.0400[/TD][TD="align:right"]25[/TD][TD="align:right"]14[/TD][TD="align:right"]195[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]68.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]68[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]66.0000[/TD][TD="align:right"]3[/TD][TD="align:right"]31[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]63.2800[/TD][TD="align:right"]25[/TD][TD="align:right"]21[/TD][TD="align:right"]118[/TD][/TR]
[TR][TD]Uruguay[/TD][TD="align:right"]60.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]53[/TD][TD="align:right"]67[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]58.6667[/TD][TD="align:right"]18[/TD][TD="align:right"]25[/TD][TD="align:right"]135[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]57.9330[/TD][TD="align:right"]209[/TD][TD="align:right"]3[/TD][TD="align:right"]225[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]56.9667[/TD][TD="align:right"]60[/TD][TD="align:right"]12[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]56.5238[/TD][TD="align:right"]21[/TD][TD="align:right"]16[/TD][TD="align:right"]192[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]56.4655[/TD][TD="align:right"]58[/TD][TD="align:right"]12[/TD][TD="align:right"]109[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]52.8800[/TD][TD="align:right"]25[/TD][TD="align:right"]18[/TD][TD="align:right"]112[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]52.6000[/TD][TD="align:right"]5[/TD][TD="align:right"]27[/TD][TD="align:right"]82[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]51.4103[/TD][TD="align:right"]39[/TD][TD="align:right"]12[/TD][TD="align:right"]115[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]50.7368[/TD][TD="align:right"]76[/TD][TD="align:right"]6[/TD][TD="align:right"]192[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]50.0000[/TD][TD="align:right"]14[/TD][TD="align:right"]24[/TD][TD="align:right"]138[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]49.5217[/TD][TD="align:right"]23[/TD][TD="align:right"]16[/TD][TD="align:right"]108[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]49.3679[/TD][TD="align:right"]405[/TD][TD="align:right"]8[/TD][TD="align:right"]441[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]45.3750[/TD][TD="align:right"]8[/TD][TD="align:right"]10[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]44.1698[/TD][TD="align:right"]106[/TD][TD="align:right"]12[/TD][TD="align:right"]167[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]43.7586[/TD][TD="align:right"]29[/TD][TD="align:right"]15[/TD][TD="align:right"]87[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]43.7500[/TD][TD="align:right"]8[/TD][TD="align:right"]6[/TD][TD="align:right"]133[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]43.2500[/TD][TD="align:right"]8[/TD][TD="align:right"]15[/TD][TD="align:right"]80[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]41.8036[/TD][TD="align:right"]56[/TD][TD="align:right"]9[/TD][TD="align:right"]147[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]39.9375[/TD][TD="align:right"]16[/TD][TD="align:right"]12[/TD][TD="align:right"]76[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]39.0000[/TD][TD="align:right"]7[/TD][TD="align:right"]25[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]38.8000[/TD][TD="align:right"]70[/TD][TD="align:right"]9[/TD][TD="align:right"]155[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]38.7111[/TD][TD="align:right"]45[/TD][TD="align:right"]13[/TD][TD="align:right"]142[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]38.2581[/TD][TD="align:right"]31[/TD][TD="align:right"]7[/TD][TD="align:right"]76[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]37.4000[/TD][TD="align:right"]5[/TD][TD="align:right"]26[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]35.2000[/TD][TD="align:right"]35[/TD][TD="align:right"]10[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]34.4375[/TD][TD="align:right"]16[/TD][TD="align:right"]21[/TD][TD="align:right"]53[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]33.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]20[/TD][TD="align:right"]46[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]32.8276[/TD][TD="align:right"]29[/TD][TD="align:right"]9[/TD][TD="align:right"]88[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]32.4146[/TD][TD="align:right"]41[/TD][TD="align:right"]8[/TD][TD="align:right"]68[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]32.1954[/TD][TD="align:right"]87[/TD][TD="align:right"]8[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]30.8281[/TD][TD="align:right"]64[/TD][TD="align:right"]9[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]30.0000[/TD][TD="align:right"]9[/TD][TD="align:right"]16[/TD][TD="align:right"]43[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]29.9474[/TD][TD="align:right"]19[/TD][TD="align:right"]10[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Tunisia[/TD][TD="align:right"]29.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]29[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]28.8333[/TD][TD="align:right"]12[/TD][TD="align:right"]17[/TD][TD="align:right"]47[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]28.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]28[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]26.0732[/TD][TD="align:right"]41[/TD][TD="align:right"]4[/TD][TD="align:right"]54[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]23.7778[/TD][TD="align:right"]9[/TD][TD="align:right"]11[/TD][TD="align:right"]36[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]20.6667[/TD][TD="align:right"]33[/TD][TD="align:right"]7[/TD][TD="align:right"]49[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]19.5000[/TD][TD="align:right"]4[/TD][TD="align:right"]5[/TD][TD="align:right"]36[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]19.2500[/TD][TD="align:right"]12[/TD][TD="align:right"]8[/TD][TD="align:right"]36[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]18.7083[/TD][TD="align:right"]24[/TD][TD="align:right"]7[/TD][TD="align:right"]43[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]18.5000[/TD][TD="align:right"]6[/TD][TD="align:right"]14[/TD][TD="align:right"]21[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]17.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]14[/TD][TD="align:right"]21[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]16.9167[/TD][TD="align:right"]24[/TD][TD="align:right"]8[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]16.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]6[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]15.0000[/TD][TD="align:right"]3[/TD][TD="align:right"]14[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]13.5000[/TD][TD="align:right"]4[/TD][TD="align:right"]10[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]13.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]9[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]11.5000[/TD][TD="align:right"]4[/TD][TD="align:right"]9[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]10.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]10[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]10.0000[/TD][TD="align:right"]10[/TD][TD="align:right"]2[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]8.1667[/TD][TD="align:right"]12[/TD][TD="align:right"]4[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]8[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]8[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]7[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]3.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Andorra[/TD][TD="align:right"]3.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]3[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]1.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]select countryId, avg(competitors) avgCompetitors, count(*) competitions, min(competitors) minCompetitors, max(competitors) maxCompetitors
from (select countryId, sum(countryId=personCountryId) competitors
from
(select distinct competitionId, countryId, personId, personCountryId
from Competitions join Results on Competitions.id=competitionId) tmp
group by competitionId) tmp2
group by countryId
order by avgCompetitors desc;[/NOPARSE]

 

[Stefan]

It's not the "most-visited" country, though. Here's counting just the foreign competitors:

Spoiler: Countries by average number of foreign competitors

Using data from WCA_export603_20150216 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]countryId[/TD][TD]avgCompetitors[/TD][TD]competitions[/TD][TD]minCompetitors[/TD][TD]maxCompetitors[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]41.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]14[/TD][TD="align:right"]69[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]39.1250[/TD][TD="align:right"]8[/TD][TD="align:right"]12[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]35.2500[/TD][TD="align:right"]4[/TD][TD="align:right"]30[/TD][TD="align:right"]43[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]34.2000[/TD][TD="align:right"]10[/TD][TD="align:right"]13[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]32.7500[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]154[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]30.2000[/TD][TD="align:right"]5[/TD][TD="align:right"]5[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]27.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]27[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]25.6250[/TD][TD="align:right"]24[/TD][TD="align:right"]10[/TD][TD="align:right"]57[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]23.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]22[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]22.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]22[/TD][TD="align:right"]22[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]19.5000[/TD][TD="align:right"]6[/TD][TD="align:right"]6[/TD][TD="align:right"]33[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]19.4444[/TD][TD="align:right"]9[/TD][TD="align:right"]11[/TD][TD="align:right"]31[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]18.2500[/TD][TD="align:right"]4[/TD][TD="align:right"]13[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]17.6829[/TD][TD="align:right"]41[/TD][TD="align:right"]0[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]15.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]14[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]14.5000[/TD][TD="align:right"]18[/TD][TD="align:right"]0[/TD][TD="align:right"]200[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]14.3289[/TD][TD="align:right"]76[/TD][TD="align:right"]0[/TD][TD="align:right"]243[/TD][/TR]
[TR][TD]Andorra[/TD][TD="align:right"]14.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]14[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]12.3333[/TD][TD="align:right"]33[/TD][TD="align:right"]0[/TD][TD="align:right"]226[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]9.8710[/TD][TD="align:right"]31[/TD][TD="align:right"]2[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]9.2500[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]9.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]9[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]9.0000[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]8.0517[/TD][TD="align:right"]58[/TD][TD="align:right"]0[/TD][TD="align:right"]71[/TD][/TR]
[TR][TD]Tunisia[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]8[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]7.7500[/TD][TD="align:right"]12[/TD][TD="align:right"]1[/TD][TD="align:right"]20[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]7.0400[/TD][TD="align:right"]25[/TD][TD="align:right"]0[/TD][TD="align:right"]30[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]7[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]7[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]5.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]5.0000[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]4.8966[/TD][TD="align:right"]87[/TD][TD="align:right"]0[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]4.8537[/TD][TD="align:right"]41[/TD][TD="align:right"]0[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]4.7857[/TD][TD="align:right"]14[/TD][TD="align:right"]0[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]4.6667[/TD][TD="align:right"]3[/TD][TD="align:right"]1[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]4.5600[/TD][TD="align:right"]25[/TD][TD="align:right"]0[/TD][TD="align:right"]21[/TD][/TR]
[TR][TD]Uruguay[/TD][TD="align:right"]4.5000[/TD][TD="align:right"]2[/TD][TD="align:right"]3[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]4.4571[/TD][TD="align:right"]35[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]4.3580[/TD][TD="align:right"]405[/TD][TD="align:right"]0[/TD][TD="align:right"]183[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]4.2632[/TD][TD="align:right"]19[/TD][TD="align:right"]1[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]4.0645[/TD][TD="align:right"]93[/TD][TD="align:right"]0[/TD][TD="align:right"]158[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]4.0625[/TD][TD="align:right"]16[/TD][TD="align:right"]0[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]3.2429[/TD][TD="align:right"]70[/TD][TD="align:right"]0[/TD][TD="align:right"]72[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]3.2000[/TD][TD="align:right"]5[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]3.0000[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]2.9375[/TD][TD="align:right"]64[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]2.6667[/TD][TD="align:right"]24[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]7[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]1.9167[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]1.8421[/TD][TD="align:right"]209[/TD][TD="align:right"]0[/TD][TD="align:right"]19[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]1.6132[/TD][TD="align:right"]106[/TD][TD="align:right"]0[/TD][TD="align:right"]39[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]1.5000[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]1.2821[/TD][TD="align:right"]39[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]1.1200[/TD][TD="align:right"]25[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]1.0435[/TD][TD="align:right"]23[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]0.9556[/TD][TD="align:right"]90[/TD][TD="align:right"]0[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]0.9375[/TD][TD="align:right"]16[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]0.7111[/TD][TD="align:right"]45[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]0.5714[/TD][TD="align:right"]21[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]0.5517[/TD][TD="align:right"]29[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]0.5357[/TD][TD="align:right"]56[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]0.5000[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]0.5000[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]0.3793[/TD][TD="align:right"]29[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]0.1667[/TD][TD="align:right"]60[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]0.0000[/TD][TD="align:right"]3[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]select countryId, avg(competitors) avgCompetitors, count(*) competitions, min(competitors) minCompetitors, max(competitors) maxCompetitors
from (select countryId, sum(countryId<>personCountryId) competitors
from
(select distinct competitionId, countryId, personId, personCountryId
from Competitions join Results on Competitions.id=competitionId) tmp
group by competitionId) tmp2
group by countryId
order by avgCompetitors desc;[/NOPARSE]

 

[Stefan]

A last one...

Ouch, from this perspective, Brazil is the second-least-visited country (only beaten by Israel).

Spoiler: Countries by 'foreignity' of competitors

Using data from WCA_export603_20150216 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]countryId[/TD][TD]foreigners per citizen[/TD][TD]avgForeigners[/TD][TD]avgCitizens[/TD][TD]competitions[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]22.00000000[/TD][TD="align:right"]22.0000[/TD][TD="align:right"]1.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]11.85714286[/TD][TD="align:right"]41.5000[/TD][TD="align:right"]3.5000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Andorra[/TD][TD="align:right"]4.66666667[/TD][TD="align:right"]14.0000[/TD][TD="align:right"]3.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]3.42000000[/TD][TD="align:right"]34.2000[/TD][TD="align:right"]10.0000[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]3.37500000[/TD][TD="align:right"]27.0000[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]3.06521739[/TD][TD="align:right"]35.2500[/TD][TD="align:right"]11.5000[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]1.43750000[/TD][TD="align:right"]23.0000[/TD][TD="align:right"]16.0000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]1.36971047[/TD][TD="align:right"]25.6250[/TD][TD="align:right"]18.7083[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]1.05405405[/TD][TD="align:right"]19.5000[/TD][TD="align:right"]18.5000[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]0.94897959[/TD][TD="align:right"]7.7500[/TD][TD="align:right"]8.1667[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]0.93589744[/TD][TD="align:right"]18.2500[/TD][TD="align:right"]19.5000[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]0.90000000[/TD][TD="align:right"]9.0000[/TD][TD="align:right"]10.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]0.89428571[/TD][TD="align:right"]39.1250[/TD][TD="align:right"]43.7500[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]0.87500000[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]0.81775701[/TD][TD="align:right"]19.4444[/TD][TD="align:right"]23.7778[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]0.67820393[/TD][TD="align:right"]17.6829[/TD][TD="align:right"]26.0732[/TD][TD="align:right"]41[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]0.66666667[/TD][TD="align:right"]9.0000[/TD][TD="align:right"]13.5000[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]0.59677419[/TD][TD="align:right"]12.3333[/TD][TD="align:right"]20.6667[/TD][TD="align:right"]33[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]0.57414449[/TD][TD="align:right"]30.2000[/TD][TD="align:right"]52.6000[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]0.45454545[/TD][TD="align:right"]15.0000[/TD][TD="align:right"]33.0000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]0.42307692[/TD][TD="align:right"]5.5000[/TD][TD="align:right"]13.0000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]0.39182453[/TD][TD="align:right"]32.7500[/TD][TD="align:right"]83.5833[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]0.31111111[/TD][TD="align:right"]4.6667[/TD][TD="align:right"]15.0000[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]0.28571429[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]0.28241701[/TD][TD="align:right"]14.3289[/TD][TD="align:right"]50.7368[/TD][TD="align:right"]76[/TD][/TR]
[TR][TD]Tunisia[/TD][TD="align:right"]0.27586207[/TD][TD="align:right"]8.0000[/TD][TD="align:right"]29.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]0.25801012[/TD][TD="align:right"]9.8710[/TD][TD="align:right"]38.2581[/TD][TD="align:right"]31[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]0.25000000[/TD][TD="align:right"]7.0000[/TD][TD="align:right"]28.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]0.24715909[/TD][TD="align:right"]14.5000[/TD][TD="align:right"]58.6667[/TD][TD="align:right"]18[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]0.21387283[/TD][TD="align:right"]9.2500[/TD][TD="align:right"]43.2500[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]0.17142857[/TD][TD="align:right"]3.0000[/TD][TD="align:right"]17.5000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]0.15763547[/TD][TD="align:right"]2.6667[/TD][TD="align:right"]16.9167[/TD][TD="align:right"]24[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]0.15208854[/TD][TD="align:right"]4.8966[/TD][TD="align:right"]32.1954[/TD][TD="align:right"]87[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]0.14973664[/TD][TD="align:right"]4.8537[/TD][TD="align:right"]32.4146[/TD][TD="align:right"]41[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]0.14259542[/TD][TD="align:right"]8.0517[/TD][TD="align:right"]56.4655[/TD][TD="align:right"]58[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]0.14235501[/TD][TD="align:right"]4.2632[/TD][TD="align:right"]29.9474[/TD][TD="align:right"]19[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]0.12662338[/TD][TD="align:right"]4.4571[/TD][TD="align:right"]35.2000[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]0.11796733[/TD][TD="align:right"]4.0625[/TD][TD="align:right"]34.4375[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]0.11125158[/TD][TD="align:right"]7.0400[/TD][TD="align:right"]63.2800[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]0.09956710[/TD][TD="align:right"]1.9167[/TD][TD="align:right"]19.2500[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]0.09571429[/TD][TD="align:right"]4.7857[/TD][TD="align:right"]50.0000[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]0.09528637[/TD][TD="align:right"]2.9375[/TD][TD="align:right"]30.8281[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]0.08827648[/TD][TD="align:right"]4.3580[/TD][TD="align:right"]49.3679[/TD][TD="align:right"]405[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]0.08556150[/TD][TD="align:right"]3.2000[/TD][TD="align:right"]37.4000[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]0.08357879[/TD][TD="align:right"]3.2429[/TD][TD="align:right"]38.8000[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]0.07575758[/TD][TD="align:right"]5.0000[/TD][TD="align:right"]66.0000[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Uruguay[/TD][TD="align:right"]0.07500000[/TD][TD="align:right"]4.5000[/TD][TD="align:right"]60.0000[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]0.06701940[/TD][TD="align:right"]4.5600[/TD][TD="align:right"]68.0400[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]0.06666667[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]30.0000[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]0.05753425[/TD][TD="align:right"]4.0645[/TD][TD="align:right"]70.6452[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]0.05128205[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]39.0000[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]0.03652285[/TD][TD="align:right"]1.6132[/TD][TD="align:right"]44.1698[/TD][TD="align:right"]106[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]0.03305785[/TD][TD="align:right"]1.5000[/TD][TD="align:right"]45.3750[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]0.03179716[/TD][TD="align:right"]1.8421[/TD][TD="align:right"]57.9330[/TD][TD="align:right"]209[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]0.02941176[/TD][TD="align:right"]2.0000[/TD][TD="align:right"]68.0000[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]0.02493766[/TD][TD="align:right"]1.2821[/TD][TD="align:right"]51.4103[/TD][TD="align:right"]39[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]0.02347418[/TD][TD="align:right"]0.9375[/TD][TD="align:right"]39.9375[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]0.02118003[/TD][TD="align:right"]1.1200[/TD][TD="align:right"]52.8800[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]0.02107111[/TD][TD="align:right"]1.0435[/TD][TD="align:right"]49.5217[/TD][TD="align:right"]23[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]0.01836969[/TD][TD="align:right"]0.7111[/TD][TD="align:right"]38.7111[/TD][TD="align:right"]45[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]0.01734104[/TD][TD="align:right"]0.5000[/TD][TD="align:right"]28.8333[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]0.01680672[/TD][TD="align:right"]0.5517[/TD][TD="align:right"]32.8276[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]0.01324707[/TD][TD="align:right"]0.9556[/TD][TD="align:right"]72.1333[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]0.01281504[/TD][TD="align:right"]0.5357[/TD][TD="align:right"]41.8036[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]0.01010952[/TD][TD="align:right"]0.5714[/TD][TD="align:right"]56.5238[/TD][TD="align:right"]21[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]0.00866824[/TD][TD="align:right"]0.3793[/TD][TD="align:right"]43.7586[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]0.00652742[/TD][TD="align:right"]0.5000[/TD][TD="align:right"]76.6000[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]0.00292569[/TD][TD="align:right"]0.1667[/TD][TD="align:right"]56.9667[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]0E-8[/TD][TD="align:right"]0.0000[/TD][TD="align:right"]79.6667[/TD][TD="align:right"]3[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]select countryId, avg(foreigners)/avg(citizens) 'foreigners per citizen', avg(foreigners) avgForeigners, avg(citizens) avgCitizens, count(*) competitions
from (select countryId, sum(countryId=personCountryId) citizens, sum(countryId<>personCountryId) foreigners
from
(select distinct competitionId, countryId, personId, personCountryId
from Competitions join Results on Competitions.id=competitionId) tmp
group by competitionId) tmp2
group by countryId
order by 2 desc;[/NOPARSE]

 

[mycube]

What's the longest period of time where no WRs were set? I just noticed because there were no WRs this year

 

[Stefan]

Spoiler: Who competed in Brazil

Using data from WCA_export603_20150216 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Country[/TD][TD]Cubers[/TD][TD][/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]1425[/TD][TD]many[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]1[/TD][TD]Francisco Javier Lemes Sáez[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]1[/TD][TD]Peng Yao Hao[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]1[/TD][TD]Jens Günther Holderer[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]1[/TD][TD]Hugo Hinojos-Kabata[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]1[/TD][TD]Natán Riggenbach[/TD][/TR]
[TR][TD]Senegal[/TD][TD="align:right"]1[/TD][TD]Pape Amady Niang[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]1[/TD][TD]Anders Larsson[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]1[/TD][TD]Kyle Koughan[/TD][/TR]
[/TABLE]

Spoiler: SQL

[NOPARSE]select personCountryId Country, count(distinct personId) Cubers, if(personCountryId='Brazil', 'many', group_concat(distinct personName)) ''
from Results
where competitionId in (select id from Competitions where countryId='Brazil')
group by personCountryId
order by Cubers desc, Country;[/NOPARSE]