Plan-of-SQLs (Ours)


Statement: pride was the away team with a result of w 11 - 10 for the game held on june 18

Ground-truth: TRUE

Input Table: 2005 philadelphia barrage season

Step 1: Select rows where 'opponent' is 'pride'.
date opponent home___away field result
9999-05-29 cannons home villanova stadium l 12 - 13
9999-06-04 lizards home villanova stadium l 14 - 19
9999-06-12 bayhawks away johnny unitas stadium l 9 - 31
9999-06-18 pride away alumni stadium (kean university) w 11 - 10
9999-06-25 lizards away mitchel athletic complex l 12 - 18
9999-06-30 cannons away nickerson field w 15 - 14
9999-07-09 rattlers away bishop kearney field w 26 - 15
9999-07-14 rattlers home villanova stadium l 10 - 14
9999-07-23 cannons away nickerson field l 10 - 11
9999-07-28 lizards home villanova stadium w 16 - 14
9999-08-04 bayhawks home villanova stadium l 9 - 19
9999-08-11 pride home villanova stadium l 12 - 16

Step 2: Select rows where 'home___away' is 'away'.
date opponent home___away field result
9999-06-18 pride away alumni stadium (kean university) w 11 - 10
9999-08-11 pride home villanova stadium l 12 - 16

Step 3: Select rows where 'result' is 'w 11 - 10'.
date opponent home___away field result
9999-06-18 pride away alumni stadium (kean university) w 11 - 10

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date opponent home___away field result
9999-06-18 pride away alumni stadium (kean university) w 11 - 10

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE