Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #435: Universal Summer Cup Stats – Part 1

AmandaTSY
5 - Atom

Similar to another user, my solution for task 2 is also producing more records than the target output likely due to the way the best athlete is filtered for. 

Supriya2203
8 - Asteroid

My solution

Annabelle
7 - Meteor

With a couple of extras... Showing the ties for places, and a medals-table style ordering where only one medal per event (not per competitor) counts.

Prathameshmanakapure
8 - Asteroid

My Solution

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
Chris-Nienart
8 - Asteroid

@griffinwelsh good insight on the ties! I also think that success could be measured by any medal, so I included medal counts (swap out for points) in my workflow too.

 

Spoiler
I used back-to-back summaries to get the max aggregated points.I used back-to-back summaries to get the max aggregated points.

 

the_data_guy
6 - Meteoroid

My solution. 

Spoiler
 
guntuv
6 - Meteoroid

C435 completed

davidhardister
8 - Asteroid
Spoiler
Capture.PNG

Luke_C
17 - Castor
Spoiler
image.png