Step 1: Select rows where 'result' is 'nominated'.
year |
category |
recipients_and_nominees |
role___episode |
result |
1996 |
best actor in a leading role - drama series |
david duchovny |
fox mulder |
won |
1996 |
best actress in a leading role - drama series |
gillian anderson |
dana scully |
nominated |
1996 |
best series - drama |
best series - drama |
best series - drama |
won |
1997 |
best actor in a leading role - drama series |
david duchovny |
david duchovny |
nominated |
1997 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
1997 |
best series - drama |
best series - drama |
best series - drama |
nominated |
1998 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
1998 |
best series - drama |
best series - drama |
best series - drama |
nominated |
2000 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
Step 2: Select rows where 'role___episode' is 'fox mulder'.
year |
category |
recipients_and_nominees |
role___episode |
result |
1996 |
best actress in a leading role - drama series |
gillian anderson |
dana scully |
nominated |
1997 |
best actor in a leading role - drama series |
david duchovny |
david duchovny |
nominated |
1997 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
1997 |
best series - drama |
best series - drama |
best series - drama |
nominated |
1998 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
1998 |
best series - drama |
best series - drama |
best series - drama |
nominated |
2000 |
best actress in a leading role - drama series |
gillian anderson |
gillian anderson |
nominated |
Step 3: Select rows where 'year' is 1996.
year |
category |
recipients_and_nominees |
role___episode |
result |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
category |
recipients_and_nominees |
role___episode |
result |
Final output table:
verification_result |
FALSE |
Prediction: FALSE