Plan-of-SQLs (Ours)


Statement: susan sarandon was the winner and nominee in 2001

Ground-truth: TRUE

Input Table: nickelodeon movies

Step 1: Select rows where 'year' is 2001.
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 'category' is 'favorite voice from an animated movie'.
year category film winner___nominee__s result
2001 favorite voice from an animated movie rugrats in paris : the movie susan sarandon won

Step 3: Select rows where 'film' is 'rugrats in paris
year category film winner___nominee__s result
2001 favorite voice from an animated movie rugrats in paris : the movie susan sarandon won

Step 4: Select rows where 'winner___nominee__s' is 'susan sarandon'.
year category film winner___nominee__s result

Step 5: 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

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: TRUE