Plan-of-SQLs (Ours)


Statement: the chicago bears were the opponents on october 16 1983

Ground-truth: TRUE

Input Table: 1983 detroit lions season

Step 1: Select rows where 'opponent' is 'chicago bears'.
week date opponent result attendance
1 1983-09-04 tampa bay buccaneers w 11 - 0 62154
2 1983-09-11 cleveland browns l 31 - 26 60095
3 1983-09-18 atlanta falcons l 30 - 14 54622
4 1983-09-25 minnesota vikings l 20 - 17 58254
5 1983-10-02 los angeles rams l 21 - 10 49403
6 1983-10-09 green bay packers w 38 - 14 67738
7 1983-10-16 chicago bears w 31 - 17 66709
8 1983-10-23 washington redskins l 38 - 17 43189
9 1983-10-30 chicago bears w 38 - 17 58764
10 1983-11-07 new york giants w 15 - 9 68985
11 1983-11-13 houston oilers l 27 - 17 40660
12 1983-11-20 green bay packers w 23 - 20 ot 50050
13 1983-11-24 pittsburgh steelers w 45 - 3 77724
14 1983-12-05 minnesota vikings w 13 - 2 79169
15 1983-12-11 cincinnati bengals l 17 - 9 45728
16 1983-12-18 tampa bay buccaneers w 23 - 20 78392

Step 2: Select rows where 'date' is '1983-10-16'.
week date opponent result attendance
7 1983-10-16 chicago bears w 31 - 17 66709
9 1983-10-30 chicago bears w 38 - 17 58764

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
7 1983-10-16 chicago bears w 31 - 17 66709

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE