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