Step 1: Select rows where 'visitor' is 'chicago black hawks'.
date |
visitor |
score |
home |
record |
'9999-04-07' |
detroit red wings |
1 - 2 |
chicago black hawks |
1 - 0 |
'9999-04-10' |
detroit red wings |
7 - 0 |
chicago black hawks |
1 - 1 |
'9999-04-12' |
chicago black hawks |
2 - 1 |
detroit red wings |
2 - 1 |
9999-04-14 |
chicago black hawks |
1 - 5 |
detroit red wings |
2 - 2 |
0000-04-17 |
detroit red wings |
5 - 3 |
chicago black hawks |
2 - 3 |
9999-04-19 |
chicago black hawks |
2 - 3 |
detroit red wings |
2 - 4 |
Step 2: Select rows where 'record' is '2 - 3'.
date |
visitor |
score |
home |
record |
'9999-04-12' |
chicago black hawks |
2 - 1 |
detroit red wings |
2 - 1 |
9999-04-14 |
chicago black hawks |
1 - 5 |
detroit red wings |
2 - 2 |
9999-04-19 |
chicago black hawks |
2 - 3 |
detroit red wings |
2 - 4 |
Step 3: Select rows where 'date' is '0000-04-17'.
date |
visitor |
score |
home |
record |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
visitor |
score |
home |
record |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE