Challenge #171: 2019 Grand Prix US - Heat 2

[ed_hayter]

Spoiler

not very efficient but join multiple is an interesting tool to use

[chandler-gjino]

attaching my solution

[tristank]

Never ran into a situation where I had to apply multiple rankings before and create an overall ranking but I thought it was a very cool situation. Took me a minute to conceptualize how to best approach it (originally was going to sort on multiple values at once before attempting a ranking)

Spoiler

[gawa]

Done

[asultanov]

Spoiler

[tammybrown_tds]

Probably not the most efficient way to solve the challenge, but it was the quickest for me.

Spoiler

[olga_strubbe]

Thank you, @JimmyG!  This was a fun challenge! 

My solution is attached. 

[geoff_zath]

Spoiler

 

[Carolyn]

Solved! At first I sorted the rank high to low and was super confused why my answer was so far off from the actual solution.

Spoiler

 

[BS_THE_ANALYST]

Step 2 threw me off. I read 3 rank IDs literally as create 3 rank IDs within each block. i.e. rank1/rank2/rank3. Gotta laugh.

Spoiler