C:\Users\Five\AppData\Local\Temp\Engine_10720_2b7b7049ba204ab6b7b3c0964a96d273_\Engine_11312_4153157b45c446e7a1b947eb55e92a00_.yxdb
Single
Profile
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #277
As we gear up for the 2021 Summer Olympics, let's take a look back at the countries and athletes that participated in the last Summer Olympics.
The "athletes" dataset contains data about the athletes who competed in the 2016 Summer Olympics in Rio de Janeiro.
The "countries" dataset contains the International Olympic Committee country code.
Find the following for each country:
- The sport with the most athletes
- The total number of athletes
- The total number of female athletes
- The total number of male athletes, and
- The average age of all athletes for each country
Data Source: https://www.kaggle.com/rio2016/olympic-games
C:\Users\Five\AppData\Local\Temp\Engine_10720_2b7b7049ba204ab6b7b3c0964a96d273_\Engine_11312_312bbc8ee938462ba32b1b3250dc5b8b_.yxdb
Single
Profile
C:\Users\Five\AppData\Local\Temp\Engine_10720_2b7b7049ba204ab6b7b3c0964a96d273_\Engine_11312_853267be898747d6ad9ec81c60e5b7c4_.yxdb
Single
Profile
Afghanistan
AFG
32526562
594.323081219966
Albania
ALB
2889167
3945.21758150914
Algeria
ALG
39666519
4206.03123244958
American Samoa*
ASA
55538
Andorra
AND
70473
Angola
ANG
25021974
4101.47215182964
Antigua and Barbuda
ANT
91818
13714.7319616988
Argentina
ARG
43416755
13431.8783398577
Armenia
ARM
3017712
3489.12768956995
Aruba*
ARU
103889
Australia
AUS
23781169
56310.9629933721
Austria
AUT
8611088
43774.985173612
Azerbaijan
AZE
9651349
5496.34464026248
Bahamas
BAH
388019
22817.2308572518
Bahrain
BRN
1377237
22600.2140981035
Bangladesh
BAN
160995642
1211.70153057661
Barbados
BAR
284215
15429.3404640853
Belarus
BLR
9513000
5740.45649479562
Belgium
BEL
11285721
40324.0277657215
Belize
BIZ
359287
4878.72126724745
Bermuda*
BER
65235
Benin
BEN
10879829
762.051205441965
Bhutan
BHU
774830
2655.99889161858
Bolivia
BOL
10724705
3076.79181060881
Bosnia and Herzegovina
BIH
3810416
4249.3303131949
Botswana
BOT
2262485
6360.13822018837
Brazil
BRA
207847528
8538.5899749574
British Virgin Islands
IVB
30117
Brunei
BRU
423188
30554.7296658073
Bulgaria
BUL
7177991
6993.47735975728
Burkina Faso
BUR
18105570
589.774414136617
Burundi
BDI
11178921
277.068309170914
Cambodia
CAM
15577899
1158.6899035244
Cameroon
CMR
23344179
1217.26067048427
Canada
CAN
35851774
43248.529909341
Cape Verde
CPV
520502
3080.17881445563
Cayman Islands*
CAY
59967
Central African Republic
CAF
4900274
323.201674024141
Chad
CHA
14037472
775.695090525313
Chile
CHI
17948141
13416.2300390185
China
CHN
1371220000
8027.68381013907
Colombia
COL
48228704
6056.14771720405
Comoros
COM
788474
717.448849960912
Congo
CGO
4620330
1851.19991555492
Congo, Dem Rep
COD
77266814
456.052740548027
Cook Islands
COK
Costa Rica
CRC
4807850
11260.0921598775
Cote d'Ivoire
CIV
22701556
1398.98995768413
Croatia
CRO
4224404
11535.8293558997
Cuba
CUB
11389562
Cyprus
CYP
1165300
23242.8400685313
Czech Republic
CZE
10551219
17548.3382129701
Denmark
DEN
5676002
51989.2934712354
Djibouti
DJI
887861
1945.12429310444
Dominica
DMA
72680
7116.38639189547
Dominican Republic
DOM
10528391
6468.4734915433
East Timor (Timor-Leste)
TLS
1245015
1157.99295590816
Ecuador
ECU
16144363
6205.06414529951
Egypt
EGY
91508084
3614.74676616271
El Salvador
ESA
6126583
4219.35032953932
Equatorial Guinea
GEQ
845060
14439.5944478516
Eritrea
ERI
Estonia
EST
1311998
17118.5042003236
Ethiopia
ETH
99390750
619.169406475891
Fiji
FIJ
892145
4960.51995438419
Finland
FIN
5482013
42311.0362306446
France
FRA
66808385
36205.5681017036
Gabon
GAB
1725292
8266.4456050624
Gambia
GAM
1990924
471.537195472347
Georgia
GEO
3679000
3795.97330845042
Germany
GER
81413145
41313.3139945434
Ghana
GHA
27409893
1369.70112227585
Greece
GRE
10823732
18002.2305776688
Grenada
GRN
106825
9212.02035173484
Guam
GUM
169885
Guatemala
GUA
16342897
3903.47885604613
Guinea
GUI
12608590
531.320595188714
Guinea-Bissau
GBS
1844325
572.988428543071
Guyana
GUY
767085
4127.35101806198
Haiti
HAI
10711067
818.343297634549
Honduras
HON
8075060
2528.89354988523
Hong Kong*
HKG
7305700
42327.8399570345
Hungary
HUN
9844686
12363.5434596539
Iceland
ISL
330823
50173.3399156473
India
IND
1311050527
1598.25903421916
Indonesia
INA
257563815
3346.48703949478
Iran
IRI
79109272
Iraq
IRQ
36423395
4943.76038832056
Ireland
IRL
4640703
61133.672427322
Israel
ISR
8380400
35728.0934951515
Italy
ITA
60802085
29957.8043154372
Jamaica
JAM
2725941
5232.02458271187
Japan
JPN
126958472
32477.2151449234
Jordan
JOR
7594547
4940.04583574111
Kazakhstan
KAZ
17544126
10509.9810699442
Kenya
KEN
46050302
1376.71282894881
Korea, North
PRK
25155317
Korea, South
KOR
50617045
27221.5240509661
Kyrgyzstan
KGZ
5957000
1103.2153515202
Laos
LAO
6802023
1818.44137293236
Latvia
LAT
1978440
13648.5475564772
Lebanon
LIB
5850743
8047.64508557496
Lesotho
LES
2135022
1066.98562625017
Liberia
LBR
4503438
455.873934536237
Libya
LBA
6278438
Liechtenstein
LIE
37531
Lithuania
LTU
2910199
14147.0493792403
Luxembourg
LUX
569676
101449.968168042
Macedonia
MKD
2078453
4852.6578476699
Madagascar
MAD
24235390
401.836006029745
Malawi
MAW
17215232
371.985747810344
Malaysia
MAS
30331007
9768.32686011881
Maldives
MDV
409163
8395.78519750383
Mali
MLI
17599694
724.256283193304
Malta
MLT
431333
22596.1817742659
Mauritania
MTN
4067564
Mauritius
MRI
1262605
9252.11072429051
Mexico
MEX
127017224
9005.02426497766
Micronesia
FSM
104460
3015.23166762397
Moldova
MDA
3554150
1848.06180430428
Monaco
MON
37731
Mongolia
MGL
2959134
3967.82938559498
Morocco
MAR
34377511
2878.20134215919
Mozambique
MOZ
27977863
529.242556068943
Burma
MYA
53897154
1161.48815791087
Namibia
NAM
2458830
4673.56724769495
Nauru
NRU
10222
9827.54428148233
Nepal
NEP
28513700
743.322965726435
Netherlands
NED
16936520
44299.768085383
New Zealand
NZL
4595700
37807.9672760442
Nicaragua
NCA
6082032
2086.89500277099
Niger
NIG
19899120
358.958152040005
Nigeria
NGR
182201962
2640.2907388575
Norway
NOR
5195921
74400.3697770928
Oman
OMA
4490541
15550.6762514328
Pakistan
PAK
188924874
1434.69666504969
Palau
PLW
21291
13498.661406228
Palestine, Occupied Territories
PLE
Panama
PAN
3929141
13268.1137549335
Papua New Guinea
PNG
7619321
Paraguay
PAR
6639123
4080.95144785437
Peru
PER
31376670
6027.12585529551
Philippines
PHI
100699395
2904.20208191528
Poland
POL
37999494
12554.5475536313
Portugal
POR
10348648
19222.1500764153
Puerto Rico*
PUR
3474182
Qatar
QAT
2235355
73653.3944346574
Romania
ROU
19832389
8972.92251840971
Russia
RUS
144096812
9092.58053606884
Rwanda
RWA
11609666
697.34822808289
Saint Kitts and Nevis
SKN
55572
15771.9455041308
Saint Lucia
LCA
184999
7735.91048440102
Saint Vincent and the Grenadines
VIN
109462
6739.17483286945
Samoa
SAM
193228
3938.54884570316
San Marino
SMR
31781
Sao Tome and Principe
STP
190344
1669.06326801326
Saudi Arabia
KSA
31540372
20481.7453220484
Senegal
SEN
15129273
899.579879484977
Serbia
SRB
7098247
5235.14220696525
Seychelles
SEY
92900
15476.01944443
Sierra Leone
SLE
6453184
653.131815940648
Singapore
SIN
5535002
52888.7446717529
Slovakia
SVK
5424050
16088.2775872723
Slovenia
SLO
2063768
20726.5398863708
Solomon Islands
SOL
583591
1934.85629287353
Somalia
SOM
10787104
549.266976567576
South Africa
RSA
54956920
5723.97335690212
Spain
ESP
46418269
25831.5823052954
Sri Lanka
SRI
20966000
3926.17439589454
Sudan
SUD
40234882
2414.72360102858
Suriname
SUR
542975
9485.31924429496
Swaziland
SWZ
1286970
3200.14301756487
Sweden
SWE
9798871
50579.6736486777
Switzerland
SUI
8286976
80945.0792194742
Syria
SYR
18502413
Taiwan
TPE
Tajikistan
TJK
8481855
925.91188767081
Tanzania
TAN
53470420
878.97510552608
Thailand
THA
67959359
5814.76976382355
Togo
TOG
7304578
559.635876661945
Tonga
TGA
106170
4098.54392925825
Trinidad and Tobago
TTO
1360088
17321.884675056
Tunisia
TUN
11107800
3872.51208364171
Turkey
TUR
78665830
9125.68758972936
Turkmenistan
TKM
5373502
6672.47754417351
Uganda
UGA
39032383
705.292569535068
Ukraine
UKR
45198200
2114.95471628444
United Arab Emirates
UAE
9156963
40438.7629344394
United Kingdom
GBR
65138232
43875.9696143686
United States
USA
321418820
56115.7184261955
Uruguay
URU
3431555
15573.9009191818
Uzbekistan
UZB
31299500
2132.07036847857
Vanuatu
VAN
264652
2805.31464353567
Venezuela
VEN
31108083
Vietnam
VIE
91703800
2111.13802366815
Virgin Islands*
ISV
103574
Yemen
YEM
26832215
1406.2916511457
Zambia
ZAM
16211767
1304.87901447726
Zimbabwe
ZIM
15602751
924.143819253412
countries
countries
atheles.yxdb
atheles.yxdb
Afghanistan
athletics
3
1
2
24.6666666666667
Albania
aquatics
6
3
3
23.6666666666667
Algeria
football
68
10
58
24.5
American Samoa*
athletics
4
1
3
25.25
Andorra
aquatics
5
3
2
25.2
Angola
handball
26
18
8
27.0769230769231
Antigua and Barbuda
athletics
9
2
7
22.3333333333333
Argentina
hockey
223
77
146
27.1838565022422
Armenia
wrestling
32
8
24
24.15625
Aruba*
sailing
7
4
3
24
Australia
aquatics
431
220
211
26.1345707656613
Austria
aquatics
71
34
37
27.8732394366197
Azerbaijan
wrestling
56
14
42
25.8571428571429
Bahamas
athletics
30
13
17
25.9
Bahrain
athletics
34
14
20
23.2647058823529
Bangladesh
aquatics
7
3
4
23.4285714285714
Barbados
athletics
11
4
7
25.1818181818182
Belarus
athletics
124
70
54
27.2177419354839
Belgium
athletics
108
34
74
26.1296296296296
Belize
athletics
3
1
2
27.3333333333333
Benin
aquatics
6
2
4
26.5
Bermuda*
aquatics
8
4
4
25.125
Bhutan
archery
2
25
Bolivia
athletics
12
6
6
25.6666666666667
Bosnia and Herzegovina
athletics
11
4
7
25.2727272727273
Botswana
athletics
12
3
9
21.8333333333333
Brazil
aquatics
485
216
269
27.4288659793814
British Virgin Islands
athletics
4
3
1
24
Brunei
athletics
3
1
2
23
Bulgaria
wrestling
50
21
29
25.42
Burkina Faso
aquatics
5
2
3
22.6
Burma
aquatics
7
3
4
26.2857142857143
Burundi
athletics
9
4
5
23.6666666666667
Cambodia
aquatics
6
4
2
29.5
Cameroon
volleyball
24
19
5
25.75
Canada
athletics
321
191
130
26.5420560747664
Cape Verde
athletics
5
3
2
22.6
Cayman Islands*
aquatics
5
2
3
23.2
Central African Republic
aquatics
6
3
3
21.6666666666667
Chad
athletics
2
1
1
23.5
Chile
athletics
42
17
25
27.0238095238095
China
aquatics
404
251
153
24.3787128712871
Colombia
football
154
76
78
25.6688311688312
Comoros
aquatics
4
2
2
21.75
Congo
table tennis
10
3
7
24.9
Congo, Dem Rep
athletics
4
2
2
24
Cook Islands
aquatics
9
5
4
23.3333333333333
Costa Rica
athletics
11
5
6
27.6363636363636
Cote d'Ivoire
athletics
12
7
5
25.6666666666667
Croatia
aquatics
88
19
69
27.2954545454545
Cuba
athletics
123
35
88
24.8130081300813
Cyprus
athletics
16
6
10
26.25
Czech Republic
athletics
104
42
62
27.6826923076923
Denmark
football
128
41
87
26.296875
Djibouti
athletics
7
1
6
21.7142857142857
Dominica
athletics
2
1
1
25
Dominican Republic
athletics
29
8
21
25.7241379310345
East Timor (Timor-Leste)
athletics
3
2
1
26
Ecuador
athletics
38
15
23
27.5789473684211
Egypt
aquatics
122
37
85
24.5983606557377
El Salvador
aquatics
8
3
5
23.125
Equatorial Guinea
athletics
2
1
1
31.5
Eritrea
athletics
12
1
11
26.25
Estonia
athletics
46
18
28
27.5
Ethiopia
athletics
38
20
18
23.6052631578947
Fiji
rugby sevens
54
17
37
24.8333333333333
Finland
athletics
54
28
26
27.5185185185185
France
athletics
410
176
234
27.1243902439024
Gabon
athletics
6
2
4
26.5
Gambia
athletics
4
1
3
21.25
Georgia
wrestling
40
10
30
25.75
Germany
athletics
441
204
237
26.4421768707483
Ghana
athletics
16
9
7
22.3125
Greece
aquatics
93
37
56
26.3118279569892
Grenada
athletics
7
2
5
22.7142857142857
Guam
aquatics
5
2
3
24
Guatemala
athletics
21
6
15
25.952380952381
Guinea
aquatics
5
3
2
19.6
Guinea-Bissau
athletics
5
2
3
27
Guyana
athletics
6
3
3
22
Haiti
athletics
10
3
7
25.2
Honduras
football
30
2
28
23.3666666666667
Hong Kong*
aquatics
38
23
15
25.3421052631579
Hungary
aquatics
154
66
88
27.0454545454545
Iceland
aquatics
8
5
3
24.375
India
hockey
123
56
67
25.739837398374
Indonesia
badminton
28
11
17
24.9642857142857
Iran
volleyball
64
9
55
26.609375
Iraq
football
26
22.3846153846154
Ireland
hockey
80
27
53
28.4875
Israel
aquatics
47
25
22
25
Italy
aquatics
312
144
168
27.1923076923077
Jamaica
athletics
57
31
26
24.8947368421053
Japan
aquatics
346
167
179
25.7080924855491
Jordan
aquatics
8
1
7
23.875
Kazakhstan
athletics
103
48
55
25.6504854368932
Kenya
athletics
80
33
47
26.4375
Korea, North
weightlifting
31
20
11
25.0967741935484
Korea, South
football
213
106
107
25.6338028169014
Kyrgyzstan
wrestling
19
7
12
24.7894736842105
Laos
aquatics
6
2
4
19.5
Latvia
athletics
32
13
19
26.71875
Lebanon
aquatics
9
5
4
26.4444444444444
Lesotho
athletics
8
1
7
25.625
Liberia
athletics
2
1
1
23.5
Libya
aquatics
7
1
6
22.8571428571429
Liechtenstein
aquatics
3
2
1
24
Lithuania
athletics
67
19
48
26.9253731343284
Luxembourg
aquatics
10
5
5
29.5
Macedonia
aquatics
6
4
2
22.1666666666667
Madagascar
aquatics
6
4
2
26.8333333333333
Malawi
aquatics
5
2
3
21.6
Malaysia
aquatics
32
15
17
24.625
Maldives
aquatics
4
2
2
21.75
Mali
aquatics
6
2
4
26.8333333333333
Malta
aquatics
7
3
4
26.5714285714286
Mauritania
athletics
2
1
1
27.5
Mauritius
athletics
11
6
5
24.6363636363636
Mexico
athletics
126
44
82
25.5714285714286
Micronesia
aquatics
5
3
2
23.8
Moldova
athletics
23
9
14
26.304347826087
Monaco
athletics
3
28.6666666666667
Mongolia
judo
43
17
26
26.3953488372093
Morocco
athletics
49
19
30
26.2448979591837
Mozambique
aquatics
6
1
5
24.8333333333333
Namibia
athletics
10
6
4
30.7
Nauru
judo
2
25
Nepal
aquatics
7
4
3
22.2857142857143
Netherlands
hockey
249
139
110
26.7871485943775
New Zealand
hockey
208
105
103
25.6009615384615
Nicaragua
aquatics
5
2
3
21.4
Niger
aquatics
6
2
4
20.8333333333333
Nigeria
athletics
78
26
52
24.9102564102564
Norway
athletics
62
33
29
27.1935483870968
Oman
athletics
4
2
2
25.75
Pakistan
aquatics
7
3
4
22.8571428571429
Palau
aquatics
5
2
3
22.6
Palestine, Occupied Territories
aquatics
6
2
4
29
Panama
athletics
10
6
4
27.7
Papua New Guinea
athletics
8
2
6
26.25
Paraguay
aquatics
11
5
6
29.5454545454545
Peru
athletics
29
12
17
26.448275862069
Philippines
athletics
13
6
7
24.8461538461538
Poland
athletics
242
100
142
27.1818181818182
Portugal
athletics
95
29
66
27.4736842105263
Puerto Rico*
athletics
40
27
13
25.8
Qatar
handball
39
2
37
26.8974358974359
Romania
athletics
98
64
34
26.5918367346939
Russia
aquatics
286
142
144
26.1473684210526
Rwanda
athletics
7
3
4
27.2857142857143
Saint Kitts and Nevis
athletics
7
1
6
27.2857142857143
Saint Lucia
athletics
5
3
2
24.2
Saint Vincent and the Grenadines
aquatics
4
2
2
20.75
Samoa
aquatics
8
3
5
25.25
San Marino
shooting
5
2
3
32
Sao Tome and Principe
athletics
3
1
2
27.3333333333333
Saudi Arabia
athletics
11
4
7
26.4545454545455
Senegal
basketball
22
16
6
29
Serbia
basketball
103
45
58
27.6407766990291
Seychelles
sailing
10
2
8
26.1
Sierra Leone
aquatics
4
2
2
22.25
Singapore
sailing
25
16
9
24.6
Slovakia
athletics
51
19
32
28.2352941176471
Slovenia
handball
63
24
39
27.047619047619
Solomon Islands
athletics
3
2
1
24.6666666666667
Somalia
athletics
2
1
1
19.5
South Africa
football
146
49
97
25.3082191780822
Spain
aquatics
313
146
167
27.8402555910543
Sri Lanka
athletics
9
2
7
28.3333333333333
Sudan
athletics
6
2
4
21.3333333333333
Suriname
aquatics
6
2
4
24.3333333333333
Swaziland
athletics
2
1
1
25.5
Sweden
football
164
91
73
27.0609756097561
Switzerland
athletics
104
46
58
26.9038461538462
Syria
aquatics
7
3
4
24.1428571428571
Taiwan
weightlifting
56
30
26
25.4642857142857
Tajikistan
aquatics
7
2
5
24.8571428571429
Tanzania
athletics
7
2
5
24.4285714285714
Thailand
weightlifting
54
28
26
26.1851851851852
Togo
aquatics
5
3
2
18.8
Tonga
aquatics
7
3
4
22.1428571428571
Trinidad and Tobago
athletics
32
11
21
26.625
Tunisia
handball
61
20
41
26.6885245901639
Turkey
athletics
103
48
55
25.7378640776699
Turkmenistan
aquatics
9
5
4
22.4444444444444
Uganda
athletics
21
7
14
23.1904761904762
Ukraine
athletics
205
118
87
26.6585365853659
United Arab Emirates
athletics
13
4
9
27.5384615384615
United Kingdom
athletics
374
169
205
27.1497326203209
United States
athletics
567
303
264
26.6084656084656
Uruguay
athletics
17
5
12
29.2352941176471
Uzbekistan
athletics
70
23
47
25.0714285714286
Vanuatu
boxing
4
23
Venezuela
athletics
88
25
63
27.2840909090909
Vietnam
fencing
23
13
10
26.4782608695652
Virgin Islands*
athletics
7
2
5
27.2857142857143
Yemen
aquatics
3
1
2
19.3333333333333
Zambia
athletics
7
2
5
24.1428571428571
Zimbabwe
football
35
26
9
26.9428571428571
male = iif(sex="male",1,0)
female = -(![male])
age = //DateTimeYear(DateTimeToda...
athletes - Descending
Country
code
country
FindWhole
Replace
Country - Ascending
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
challenge_277_start_file