Step 1: Select rows where 'film' is 'rugrats go wild'.
year |
category |
film |
winner___nominee__s |
result |
1997 |
favorite movie actress |
harriet the spy |
rosie o'donnell |
nominated |
1999 |
favorite movie |
the rugrats movie |
n / a |
won |
2001 |
favorite voice from an animated movie |
rugrats in paris : the movie |
susan sarandon |
won |
2004 |
favorite voice from an animated movie |
rugrats go wild |
bruce willis |
nominated |
2005 |
favorite movie actor |
lemony snicket 's a series of unfortunate events |
jim carrey |
nominated |
2007 |
favorite movie actor |
nacho libre |
jack black |
nominated |
2007 |
favorite movie actress |
charlotte 's web |
dakota fanning |
won |
2012 |
favorite voice from an animated movie |
rango |
johnny depp |
nominated |
Step 2: Select rows where 'result' is 'nominated'.
year |
category |
film |
winner___nominee__s |
result |
2004 |
favorite voice from an animated movie |
rugrats go wild |
bruce willis |
nominated |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
category |
film |
winner___nominee__s |
result |
2004 |
favorite voice from an animated movie |
rugrats go wild |
bruce willis |
nominated |
Prediction: TRUE
Ground-truth: TRUE