Plan-of-SQLs (Ours)


Statement: the game against opponent buffalo sabres had an attendance of 10750

Ground-truth: FALSE

Input Table: 2008 - 09 tampa bay lightning season

Step 1: Select rows where 'opponent' is 'buffalo sabres'.
game date opponent score location attendance record points
37 9999-01-01 washington capitals 4 - 7 verizon center 18227 10 - 17 - 10 30
38 0001-01-03 carolina hurricanes 2 - 3 st pete times forum 15873 10 - 18 - 10 30
39 0001-01-04 atlanta thrashers 4 - 1 philips arena 10750 11 - 18 - 10 32
40 0001-01-08 phoenix coyotes 1 - 4 jobingcom arena 13736 11 - 19 - 10 32
41 0000-01-09 anaheim ducks 4 - 3 honda center 17174 12 - 19 - 10 34
42 0001-01-12 los angeles kings 3 - 1 staples center 16511 13 - 19 - 10 36
43 0001-01-13 san jose sharks 1 - 7 hp pavilion at san jose 17496 13 - 20 - 10 36
44 0000-01-15 philadelphia flyers 4 - 1 st pete times forum 15604 14 - 20 - 10 38
45 0000-01-17 florida panthers 3 - 4 st pete times forum 17217 14 - 21 - 10 38
46 9999-01-19 dallas stars 4 - 2 st pete times forum 13991 15 - 21 - 10 40
47 9999-01-21 buffalo sabres 5 - 3 st pete times forum 15611 16 - 21 - 10 42
48 9999-01-27 montreal canadiens 5 - 3 st pete times forum 15912 17 - 21 - 10 44
49 9999-01-29 carolina hurricanes 2 - 3 rbc center 16405 17 - 22 - 10 44
50 0000-01-30 philadelphia flyers 1 - 6 st pete times forum 18120 17 - 23 - 10 44

Step 2: Select rows where 'attendance' is 10750.
game date opponent score location attendance record points
47 9999-01-21 buffalo sabres 5 - 3 st pete times forum 15611 16 - 21 - 10 42

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
game date opponent score location attendance record points

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE