Step 1: Select rows where 'award_ceremony' is 'drama desk award'.
year |
award_ceremony |
category |
nominee |
result |
2009 |
tony award |
best play |
neil labute |
nominated |
2009 |
tony award |
best performance by a leading actor in a play |
thomas sadoski |
nominated |
2009 |
tony award |
best performance by a featured actress in a play |
marin ireland |
nominated |
2009 |
drama desk award |
outstanding play |
outstanding play |
nominated |
2009 |
drama desk award |
outstanding actor in a play |
thomas sadoski |
nominated |
2009 |
drama desk award |
outstanding director of a play |
terry kinney |
nominated |
2009 |
theatre world award |
theatre world award |
marin ireland |
won |
Step 2: Select rows where 'year' is before 2009.
year |
award_ceremony |
category |
nominee |
result |
2009 |
drama desk award |
outstanding play |
outstanding play |
nominated |
2009 |
drama desk award |
outstanding actor in a play |
thomas sadoski |
nominated |
2009 |
drama desk award |
outstanding director of a play |
terry kinney |
nominated |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
award_ceremony |
category |
nominee |
result |
Final output table:
verification_result |
FALSE |
Prediction: FALSE