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 |
Prediction: TRUE