Step 1: Select rows where 'attendance' is less than or equal to 32343.
week |
date |
opponent |
result |
attendance |
1 |
1983-09-04 |
buffalo bills |
w 12 - 0 |
78715 |
2 |
1983-09-11 |
new england patriots |
w 34 - 24 |
59343 |
3 |
1983-09-19 |
los angeles raiders |
l 27 - 14 |
57796 |
4 |
1983-09-25 |
kansas city chiefs |
w 14 - 6 |
50785 |
5 |
1983-10-02 |
new orleans saints |
l 17 - 7 |
66489 |
6 |
1983-10-09 |
buffalo bills |
l 38 - 35 |
59948 |
7 |
1983-10-16 |
new york jets |
w 32 - 14 |
58615 |
8 |
1983-10-23 |
baltimore colts |
w 21 - 7 |
32343 |
9 |
1983-10-30 |
los angeles rams |
w 30 - 14 |
72175 |
10 |
1983-11-06 |
san francisco 49ers |
w 20 - 17 |
57832 |
11 |
1983-11-13 |
new england patriots |
l 17 - 6 |
60771 |
12 |
1983-11-20 |
baltimore colts |
w 37 - 0 |
54482 |
13 |
1983-11-28 |
cincinnati bengals |
w 38 - 14 |
74506 |
14 |
1983-12-04 |
houston oilers |
w 24 - 17 |
39434 |
15 |
1983-12-10 |
atlanta falcons |
w 31 - 24 |
56725 |
16 |
1983-12-16 |
new york jets |
w 34 - 14 |
59975 |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
week |
date |
opponent |
result |
attendance |
8 |
1983-10-23 |
baltimore colts |
w 21 - 7 |
32343 |
Prediction: TRUE
Ground-truth: TRUE