Challenge #416: The Oscars 2024

[wheezy]

Really fun one! 🥇

[tsand22]

OL Solution

[JohnFM95]

😃.

[mattnason1]

This one's pretty involved for a core.

[celuck]

This was my first challenge so it is a little messy and I need to combine it all into one workflow, but I did get the right answers! This was a fun challenge!

[Rob-Silk]

Solution attached below

Not sure if others have already mentioned it, but I found difference between my answer and the solution output for Task 3 ("Task 3: Actors/Actresses who won every time they were nominated"). In the solution output there are 117 records of which one 1 "Daniel Day Lewis" with 1 nomination and 1 award. In the data set (CSV) that I have from when I downloaded the challenge, the name is spelt "Daniel Day-Lewis" and he has 6 nominations with 3 awards, meaning that he doesn't fit the criteria for the Task 3 output.

Spoiler

[caltang]

Nice challenge @Qiu !

Spoiler

I am quite confused by No. 3's answer though...

Spoiler

The answer includes Daniel Day-Lewis - but the data shows that he did not win every time he was nominated. He lost out in 1994 and 2003. But I looked at your answer and saw Daniel Day Lewis, without the hypen "-". Can we confirm this?

[Qiu]

@Rob-Silk 
Thank you for finding that out.
Nice one.👍

[synergy825]

Spoiler

[Erin]

Congrats @Qiu!

My solution is different for Task 3: Actors/Actresses who won every time they were nominated.

Spoiler

Daniel Day-Lewis didn't win every time.