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
My solution, with the correct answer to 8 greater nominations than wins but without cleaning up the names in the source data to fix Daniel Day Lewis' multiple names. He's another Lewis. I like to see him on the always wins list.
The >8 issue with Peter O'Toole calls out a common design pattern where we want the output of a join but also need to catch one side (which should be the left if we're designing carefully but sometimes we don't) of the output and treat some value there as a default. In our work (Financial process development) we see a lot of this where we're matching everything we can but still maintaining the full source dataset.
Congratulations to @Qiu
All 5 tasks are done!
