Step 1: Select rows where 'team' is 'nets'.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
75 |
9999-04-01 |
philadelphia |
l 90 - 115 (ot) |
brandan wright (15) |
brandan wright (11) |
deron williams (7) |
wells fargo center 16695 |
23 - 52 |
76 |
9999-04-03 |
miami |
l 94 - 108 (ot) |
deron williams (18) |
travis outlaw (9) |
deron williams (9) |
prudential center 18711 |
23 - 53 |
77 |
'9999-04-05' |
minnesota |
w 107 - 105 (ot) |
brook lopez (30) |
brook lopez (12) |
deron williams (21) |
prudential center 13461 |
24 - 53 |
78 |
9999-04-06 |
detroit |
l 109 - 116 (ot) |
brook lopez (39) |
brook lopez (7) |
jordan farmar (11) |
the palace of auburn hills 14554 |
24 - 54 |
79 |
9999-04-08 |
new york |
l 93 - 116 (ot) |
brook lopez (27) |
jordan farmar (8) |
jordan farmar (9) |
prudential center 18023 |
24 - 55 |
80 |
'9999-04-10' |
toronto |
l 92 - 99 (ot) |
brook lopez (35) |
brook lopez (11) |
jordan farmar (7) |
air canada centre 17755 |
24 - 56 |
81 |
9999-04-11 |
charlotte |
l 103 - 105 (ot) |
brook lopez (31) |
dan gadzuric (8) |
jordan farmar (9) |
prudential center 13853 |
24 - 57 |
Step 2: Select rows where 'score' contains 'W'.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
Step 3: Select rows where 'location_attendance' contains 'air canada centre'.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE