Step 1: Select rows where 'opponent' is 'rattlers'.
date |
opponent |
home___away |
field |
result |
9999-05-29 |
cannons |
home |
villanova stadium |
l 12 - 13 |
9999-06-04 |
lizards |
home |
villanova stadium |
l 14 - 19 |
9999-06-12 |
bayhawks |
away |
johnny unitas stadium |
l 9 - 31 |
9999-06-18 |
pride |
away |
alumni stadium (kean university) |
w 11 - 10 |
9999-06-25 |
lizards |
away |
mitchel athletic complex |
l 12 - 18 |
9999-06-30 |
cannons |
away |
nickerson field |
w 15 - 14 |
9999-07-09 |
rattlers |
away |
bishop kearney field |
w 26 - 15 |
9999-07-14 |
rattlers |
home |
villanova stadium |
l 10 - 14 |
9999-07-23 |
cannons |
away |
nickerson field |
l 10 - 11 |
9999-07-28 |
lizards |
home |
villanova stadium |
w 16 - 14 |
9999-08-04 |
bayhawks |
home |
villanova stadium |
l 9 - 19 |
9999-08-11 |
pride |
home |
villanova stadium |
l 12 - 16 |
Step 2: Select rows where 'field' is 'bishop kearney field'.
date |
opponent |
home___away |
field |
result |
9999-07-09 |
rattlers |
away |
bishop kearney field |
w 26 - 15 |
9999-07-14 |
rattlers |
home |
villanova stadium |
l 10 - 14 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
opponent |
home___away |
field |
result |
9999-07-09 |
rattlers |
away |
bishop kearney field |
w 26 - 15 |
Prediction: TRUE
Ground-truth: TRUE