Challenge #416: The Oscars 2024
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
DaisukeTsuchiya
14 - Magnetar
03-06-2024
04:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DaisukeTsuchiya
14 - Magnetar
03-06-2024
04:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
NatSnook
8 - Asteroid
03-07-2024
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Done -thanks :)
achisman
7 - Meteor
03-07-2024
06:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
davidblack
7 - Meteor
03-07-2024
07:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
acurrul
6 - Meteoroid
03-07-2024
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Christian_Erickson
6 - Meteoroid
03-08-2024
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ScottLewis
11 - Bolide
03-08-2024
09:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
ARussell34
8 - Asteroid
03-08-2024
12:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nick_hartley
6 - Meteoroid
03-08-2024
02:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator