Plan-of-SQLs (Ours)


Statement: week 12 was on december 2 , 2001

Ground-truth: TRUE

Input Table: 2001 cincinnati bengals season

Step 1: Select rows where 'week' is 12.
week date opponent result attendance
1 2001-09-09 new england patriots w 23 - 17 51521
2 2001-09-23 baltimore ravens w 21 - 10 51121
3 2001-09-30 san diego chargers l 28 - 14 56048
4 2001-10-07 pittsburgh steelers l 16 - 7 62335
5 2001-10-14 cleveland browns w 24 - 14 64217
6 2001-10-21 chicago bears l 24 - 0 63408
7 2001-10-28 detroit lions w 31 - 27 69343
9 2001-11-11 jacksonville jaguars l 30 - 13 57161
10 2001-11-18 tennessee titans l 20 - 7 63865
11 2001-11-25 cleveland browns l 18 - 0 72918
12 2001-12-02 tampa bay buccaneers l 16 - 13 52135
13 2001-12-09 jacksonville jaguars l 14 - 10 44920
14 2001-12-16 new york jets l 15 - 14 77745
15 2001-12-23 baltimore ravens l 16 - 0 68987
16 2001-12-30 pittsburgh steelers w 26 - 23 63751
17 2002-01-06 tennessee titans w 23 - 21 68798

Step 2: Select rows where 'date' is '2001-12-02'.
week date opponent result attendance
12 2001-12-02 tampa bay buccaneers l 16 - 13 52135

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
week date opponent result attendance
12 2001-12-02 tampa bay buccaneers l 16 - 13 52135

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE