C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_5c20c5cacbf04291b4ff4b38f939242f_.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 #283
C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_bda5aba2963445caa2549994a08bff9f_.yxdb
Single
Profile
C:\Users\Admin\Desktop\CRG\Challenges\ALteryx\Challenge 283\challenge_283_start_file\dataset_athletes.yxdb
dataset_athletes.yxdb
Afghanistan
5
Albania
8
Algeria
41
American Samoa
5
Andorra
2
Angola
20
Antigua and Barbuda
6
Argentina
180
Armenia
16
Aruba
3
Australia
470
Austria
72
Azerbaijan
41
Bahamas
16
Bahrain
31
Bangladesh
6
Barbados
7
Belarus
104
Belgium
125
Belize
3
Benin
7
Bermuda
2
Bhutan
3
Bolivia
5
Bosnia and Herzegovina
7
Botswana
13
Brazil
291
Brunei Darussalam
2
Bulgaria
41
Burkina Faso
7
Burundi
6
Cambodia
3
Cameroon
11
Canada
368
Cape Verde
6
Cayman Islands
5
Central African Republic
2
Chad
3
Chile
56
Chinese Taipei
67
Colombia
64
Comoros
3
Congo
3
Cook Islands
6
Costa Rica
13
Croatia
57
Cuba
69
Cyprus
14
Czech Republic
117
Côte d'Ivoire
29
Democratic Republic of Timor-Leste
3
Democratic Republic of the Congo
7
Denmark
103
Djibouti
4
Dominica
2
Dominican Republic
61
Ecuador
46
Egypt
133
El Salvador
5
Equatorial Guinea
3
Eritrea
13
Estonia
33
Eswatini
4
Ethiopia
42
Federated States of Micronesia
3
Fiji
28
Finland
45
France
377
Gabon
5
Gambia
3
Georgia
35
Germany
400
Ghana
14
Great Britain
366
Greece
75
Grenada
6
Guam
5
Guatemala
22
Guinea
5
Guinea-Bissau
4
Guyana
7
Haiti
6
Honduras
25
Hong Kong, China
40
Hungary
155
Iceland
4
India
117
Indonesia
26
Iraq
4
Ireland
116
Islamic Republic of Iran
66
Israel
85
Italy
356
Jamaica
60
Japan
586
Jordan
11
Kazakhstan
92
Kenya
78
Kiribati
3
Kosovo
10
Kuwait
10
Kyrgyzstan
16
Lao People's Democratic Republic
4
Latvia
29
Lebanon
6
Lesotho
2
Liberia
3
Libya
4
Liechtenstein
5
Lithuania
37
Luxembourg
11
Madagascar
6
Malawi
5
Malaysia
29
Maldives
4
Mali
4
Malta
6
Marshall Islands
2
Mauritania
2
Mauritius
7
Mexico
155
Monaco
6
Mongolia
43
Montenegro
35
Morocco
48
Mozambique
8
Myanmar
2
Namibia
11
Nauru
2
Nepal
5
Netherlands
274
New Zealand
202
Nicaragua
8
Niger
7
Nigeria
59
North Macedonia
8
Norway
92
Oman
5
Pakistan
10
Palau
3
Palestine
4
Panama
9
Papua New Guinea
7
Paraguay
8
People's Republic of China
401
Peru
33
Philippines
18
Poland
195
Portugal
85
Puerto Rico
35
Qatar
14
ROC
318
Refugee Olympic Team
26
Republic of Korea
223
Republic of Moldova
19
Romania
99
Rwanda
5
Saint Kitts and Nevis
2
Saint Lucia
5
Samoa
8
San Marino
4
Sao Tome and Principe
3
Saudi Arabia
32
Senegal
9
Serbia
83
Seychelles
5
Sierra Leone
4
Singapore
23
Slovakia
38
Slovenia
51
Solomon Islands
3
Somalia
2
South Africa
171
South Sudan
2
Spain
324
Sri Lanka
9
St Vincent and the Grenadines
2
Sudan
5
Suriname
3
Sweden
129
Switzerland
115
Syrian Arab Republic
6
Tajikistan
8
Thailand
39
Togo
4
Tonga
5
Trinidad and Tobago
31
Tunisia
57
Turkey
102
Turkmenistan
8
Tuvalu
2
Uganda
24
Ukraine
152
United Arab Emirates
4
United Republic of Tanzania
2
United States of America
615
Uruguay
11
Uzbekistan
63
Vanuatu
2
Venezuela
43
Vietnam
17
Virgin Islands, British
3
Virgin Islands, US
4
Yemen
3
Zambia
29
Zimbabwe
5
List the participating countries and how many athletes for each country
List the participating countries and how many athletes for each country
United States of America
615
Japan
586
Australia
470
People's Republic of China
401
Germany
400
List of the 5 countries with the most athletes
List of the 5 countries with the most athletes
C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_e31d80b1e02447c9ad561013c12a8d83_.yxdb
Single
Profile
C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_e8ad87bebbe64919860c391abed9b70d_.yxdb
Single
Profile
Andorra
2
Bermuda
2
Brunei Darussalam
2
Central African Republic
2
Dominica
2
List the first 5 countries (alphabetic order) with the least athletes
List the first 5 countries (alphabetic order) with the least athletes
C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_e42a27fe3c084e7b839deaf07d6c51c9_.yxdb
C:\Users\Admin\Desktop\CRG\Challenges\ALteryx\Challenge 283\challenge_283_start_file\Ouptput.yxdb
List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID
Ouptput.yxdb
C:\Users\Admin\AppData\Local\Temp\Engine_9812_9d82f415d32e4d4899058d2c8168c82b_\Engine_9680_ee8e7a92f9034df0abd4ea68b0387dec_.yxdb
Single
Profile
Count - Descending
First
5
First 5
Count - Ascending
First
5
First 5
,
NOC - Ascending
Discipline - Ascending
Count - Descending
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
Solution 283