Plan-of-SQLs (Ours)


Statement: bruce willis was nominated for the film rugrats go wild

Ground-truth: TRUE

Input Table: nickelodeon movies

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

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE