Plan-of-SQLs (Ours)

Statement: when the indianapolis colts were the visiting team at giants stadium , the final score was 26 - 21

Ground-truth: TRUE

Input Table: nbc sunday night football results (2006 - present)

Step 1: Select rows where 'visiting_team' is 'indianapolis colts'.
date visiting_team final_score host_team stadium
9999-09-07 miami dolphins 17 - 28 pittsburgh steelers heinz field
9999-09-10 indianapolis colts 26 - 21 new york giants giants stadium
9999-09-17 washington redskins 10 - 27 dallas cowboys texas stadium
9999-09-24 denver broncos 17 - 7 new england patriots gillette stadium
9999-10-01 seattle seahawks 6 - 37 chicago bears soldier field
9999-10-08 pittsburgh steelers 13 - 23 san diego chargers qualcomm stadium
9999-10-15 oakland raiders 3 - 13 denver broncos invesco field at mile high
9999-10-29 dallas cowboys 35 - 14 carolina panthers bank of america stadium
9999-11-05 indianapolis colts 27 - 20 new england patriots gillette stadium
9999-11-12 chicago bears 38 - 20 new york giants giants stadium
9999-11-19 san diego chargers 35 - 27 denver broncos invesco field at mile high
9999-11-26 philadelphia eagles 21 - 45 indianapolis colts rca dome
9999-12-03 seattle seahawks 23 - 20 denver broncos invesco field at mile high
9999-12-10 new orleans saints 42 - 17 dallas cowboys texas stadium
9999-12-17 kansas city chiefs 9 - 20 san diego chargers qualcomm stadium
9999-12-25 philadelphia eagles 23 - 7 dallas cowboys texas stadium
9999-12-31 green bay packers 26 - 7 chicago bears soldier field
0001-01-06 kansas city chiefs 8 - 23 indianapolis colts rca dome
0001-01-06 dallas cowboys 20 - 21 seattle seahawks qwest field
Step 2: Select rows where 'host_team' is 'new york giants'.
date visiting_team final_score host_team stadium
9999-09-10 indianapolis colts 26 - 21 new york giants giants stadium
9999-11-05 indianapolis colts 27 - 20 new england patriots gillette stadium
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date visiting_team final_score host_team stadium
9999-09-10 indianapolis colts 26 - 21 new york giants giants stadium
Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE