Plan-of-SQLs (Ours)


Statement: the nets' only win came at the air canada centre

Ground-truth: FALSE

Input Table: 2010 - 11 new jersey nets season

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