Step 1: Select rows where 'away_team' is 'derby county'.
tie_no |
home_team |
score |
away_team |
date |
1 |
notts county |
1 - 2 |
everton |
1984-03-10 |
2 |
sheffield wednesday |
0 - 0 |
southampton |
1984-03-11 |
replay |
southampton |
5 - 1 |
sheffield wednesday |
1984-03-20 |
3 |
plymouth argyle |
0 - 0 |
derby county |
1984-03-10 |
replay |
derby county |
0 - 1 |
plymouth argyle |
1984-03-14 |
4 |
birmingham city |
1 - 3 |
watford |
1984-03-10 |
Step 2: Select rows where 'date' is after '1984-03-14'.
tie_no |
home_team |
score |
away_team |
date |
3 |
plymouth argyle |
0 - 0 |
derby county |
1984-03-10 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
tie_no |
home_team |
score |
away_team |
date |
Final output table:
verification_result |
FALSE |
Prediction: FALSE