Plan-of-SQLs (Ours)


Statement: the game against new orleans had the highest attendance

Ground-truth: FALSE

Input Table: 2008 - 09 phoenix suns season

Step 1: Select rows where 'location_attendance' is not empty.
game date team location_attendance record
75 april 1 houston us airways center 18422 41 - 34
76 april 3 sacramento us airways center 18422 42 - 34
77 april 5 dallas american airlines center 20301 42 - 35
78 april 8 new orleans new orleans arena 17781 43 - 35
79 april 10 memphis fedexforum 15908 43 - 36
80 april 11 minnesota target center 18478 44 - 36
81 april 13 memphis us airways center 18422 45 - 36
82 april 15 golden state us airways center 46 - 36

Step 2: Extract the numerical attendance from the 'location_attendance' column by identifying the number before the space to add column 'attendance' to existing table.
game date team location_attendance record
75 april 1 houston us airways center 18422 41 - 34
76 april 3 sacramento us airways center 18422 42 - 34
77 april 5 dallas american airlines center 20301 42 - 35
78 april 8 new orleans new orleans arena 17781 43 - 35
79 april 10 memphis fedexforum 15908 43 - 36
80 april 11 minnesota target center 18478 44 - 36
81 april 13 memphis us airways center 18422 45 - 36
82 april 15 golden state us airways center 46 - 36

Step 3: Cast to INT and order the table by 'attendance' in descending order and select the first row.
game date team location_attendance record attendance
75 april 1 houston us airways center 18422 41 - 34 0
76 april 3 sacramento us airways center 18422 42 - 34 0
77 april 5 dallas american airlines center 20301 42 - 35 0
78 april 8 new orleans new orleans arena 17781 43 - 35 0
79 april 10 memphis fedexforum 15908 43 - 36 15908
80 april 11 minnesota target center 18478 44 - 36 0
81 april 13 memphis us airways center 18422 45 - 36 0
82 april 15 golden state us airways center 46 - 36 0

Step 4: Select rows where 'team' is 'new orleans'.
game date team location_attendance record attendance
79 april 10 memphis fedexforum 15908 43 - 36 15908

Step 5: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
game date team location_attendance record attendance

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE