Step 1: Select rows where 'venue' is 'away'.
| date |
opponent |
venue |
result |
attendance |
competition |
man_of_the_match |
| 9999-01-01 |
slough jets |
home |
lost 2 - 3 |
1308 |
league / cup |
lukas smital |
| 9999-01-02 |
slough jets |
away |
lost 5 - 6 (ot) |
320 |
league |
paul dixon |
| 9999-01-08 |
swindon wildcats |
away |
won 6 - 3 |
754 |
league / cup |
lukas smital |
| 9999-01-09 |
swindon wildcats |
home |
won 4 - 2 |
1568 |
league / cup |
neil liddiard |
| 9999-01-15 |
sheffield scimitars |
away |
won 7 - 4 |
364 |
league / cup |
rick plant |
| 9999-01-16 |
milton keynes lightning |
home |
lost 2 - 4 |
1161 |
league / cup |
david savage |
| 9999-01-19 |
romford raiders |
home |
won 6 - 2 |
1016 |
league / cup |
alex mettam |
| 9999-01-22 |
wightlink raiders |
away |
lost 5 - 4 |
509 |
league / cup |
stuart potts |
| 9999-01-23 |
telford tigers |
home |
won 4 - 2 |
1368 |
league |
alex mettam / mark williams |
| 9999-01-29 |
romford raiders |
home |
won 7 - 2 |
1238 |
league |
martin bouz |
| 9999-01-30 |
bracknell bees |
away |
won 4 - 0 |
not reported |
league / cup |
joe watkins |
Step 2: Select rows where 'opponent' is 'wightlink raiders'.
| date |
opponent |
venue |
result |
attendance |
competition |
man_of_the_match |
| 9999-01-02 |
slough jets |
away |
lost 5 - 6 (ot) |
320 |
league |
paul dixon |
| 9999-01-08 |
swindon wildcats |
away |
won 6 - 3 |
754 |
league / cup |
lukas smital |
| 9999-01-15 |
sheffield scimitars |
away |
won 7 - 4 |
364 |
league / cup |
rick plant |
| 9999-01-22 |
wightlink raiders |
away |
lost 5 - 4 |
509 |
league / cup |
stuart potts |
| 9999-01-30 |
bracknell bees |
away |
won 4 - 0 |
not reported |
league / cup |
joe watkins |
Step 3: Select rows where 'result' is '5 - 4 loss'.
| date |
opponent |
venue |
result |
attendance |
competition |
man_of_the_match |
| 9999-01-22 |
wightlink raiders |
away |
lost 5 - 4 |
509 |
league / cup |
stuart potts |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| date |
opponent |
venue |
result |
attendance |
competition |
man_of_the_match |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE
Ground-truth: TRUE