Step 1: Select rows where 'visitor' is 'new jersey'.
date |
visitor |
score |
home |
record |
9999-02-03 |
ny islanders |
7 - 2 |
new jersey |
11 - 32 - 11 |
9999-02-05 |
new jersey |
4 - 5 |
washington |
11 - 33 - 11 |
9999-02-06 |
vancouver |
4 - 4 |
new jersey |
11 - 33 - 12 |
9999-02-09 |
new jersey |
4 - 5 |
chicago |
11 - 34 - 12 |
01-02-12 |
new jersey |
1 - 5 |
st louis |
11 - 35 - 12 |
01-02-15 |
minnesota |
3 - 2 |
new jersey |
11 - 36 - 12 |
9999-02-20 |
new jersey |
0 - 3 |
philadelphia |
11 - 37 - 12 |
01-02-21 |
buffalo |
4 - 4 |
new jersey |
11 - 37 - 13 |
9999-02-24 |
detroit |
1 - 4 |
new jersey |
12 - 37 - 13 |
9999-02-26 |
new jersey |
4 - 5 |
pittsburgh |
12 - 38 - 13 |
9999-02-27 |
new jersey |
2 - 6 |
buffalo |
12 - 39 - 13 |
Step 2: Select rows where 'home' is 'vancouver'.
date |
visitor |
score |
home |
record |
9999-02-05 |
new jersey |
4 - 5 |
washington |
11 - 33 - 11 |
9999-02-09 |
new jersey |
4 - 5 |
chicago |
11 - 34 - 12 |
01-02-12 |
new jersey |
1 - 5 |
st louis |
11 - 35 - 12 |
9999-02-20 |
new jersey |
0 - 3 |
philadelphia |
11 - 37 - 12 |
9999-02-26 |
new jersey |
4 - 5 |
pittsburgh |
12 - 38 - 13 |
9999-02-27 |
new jersey |
2 - 6 |
buffalo |
12 - 39 - 13 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
date |
visitor |
score |
home |
record |
Final output table:
verification_result |
FALSE |
Prediction: FALSE