Plan-of-SQLs (Ours)


Statement: only one game was played on november 27

Ground-truth: TRUE

Input Table: 2009 - 10 temple owls men 's basketball team

Step 1: Select rows where 'date' is '9999-11-27'.
game date team score high_points high_rebounds high_assists location_attendance record
1 9999-11-14 delaware w 76 - 56 ryan brooks - 23 lavoy allen - 15 juan fernandez - 5 bob carpenter center , newark , de (3080) 1 - 0
2 9999-11-17 georgetown (19) l 46 - 45 allen - 12 allen - 14 luiz guzman - 6 verizon center , washington , dc (8712) 1 - 1
3 9999-11-21 siena w 73 - 69 fernandez - 20 allen - 7 allen - 5 liacouras center , philadelphia , pa (6759) 2 - 1
4 9999-11-24 ball state w 66 - 46 brooks - 17 allen - 9 allen / brooks - 7 liacouras center , philadelphia , pa (3597) 3 - 1
5 9999-11-27 virginia tech w 61 - 50 allen - 18 allen - 10 fernandez - 6 palestra , philadelphia , pa (3750) 4 - 1

Step 2: 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
5 9999-11-27 virginia tech w 61 - 50 allen - 18 allen - 10 fernandez - 6 palestra , philadelphia , pa (3750) 4 - 1

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE