Step 1: Select rows where 'attendance' is 66189.
| week |
date |
opponent |
result |
record |
tv_time |
attendance |
| 1 |
2001-09-09 |
philadelphia eagles |
w 20 - 17 (ot) |
1 - 0 |
fox 3:15 pm |
66243.0 |
| 2 |
2001-09-23 |
san francisco 49ers |
w 30 - 26 |
2 - 0 |
fox 3:15 pm |
67536.0 |
| 3 |
2001-09-30 |
miami dolphins |
w 42 - 10 |
3 - 0 |
cbs 12:00 pm |
66046.0 |
| 4 |
2001-10-08 |
detroit lions |
w 35 - 0 |
4 - 0 |
abc 8:00 pm |
77765.0 |
| 5 |
2001-10-14 |
new york giants |
w 15 - 14 |
5 - 0 |
fox 12:00 pm |
65992.0 |
| 6 |
2001-10-21 |
new york jets |
w 34 - 14 |
6 - 0 |
fox 12:00 pm |
78766.0 |
| 7 |
2001-10-28 |
new orleans saints |
l 34 - 31 |
6 - 1 |
fox 12:00 pm |
66189.0 |
| 8 |
9999-01-01 |
- |
- |
- |
- |
nan |
| 9 |
2001-11-11 |
carolina panthers |
w 48 - 14 |
7 - 1 |
fox 12:00 pm |
66069.0 |
| 10 |
2001-11-18 |
new england patriots |
w 24 - 17 |
8 - 1 |
espn 7:30 pm |
60292.0 |
| 11 |
2001-11-26 |
tampa bay buccaneers |
l 24 - 17 |
8 - 2 |
abc 8:00 pm |
66198.0 |
| 12 |
2001-12-02 |
atlanta falcons |
w 35 - 6 |
9 - 2 |
fox 3:15 pm |
60787.0 |
| 13 |
2001-12-09 |
san francisco 49ers |
w 27 - 14 |
10 - 2 |
fox 12:00 pm |
66218.0 |
| 14 |
2001-12-17 |
new orleans saints |
w 34 - 21 |
11 - 2 |
abc 8:00 pm |
70332.0 |
| 15 |
2001-12-23 |
carolina panthers |
w 38 - 32 |
12 - 2 |
fox 12:00 pm |
72438.0 |
| 16 |
2001-12-30 |
indianapolis colts |
w 42 - 17 |
13 - 2 |
cbs 12:00 pm |
66084.0 |
| 17 |
2002-01-06 |
atlanta falcons |
w 31 - 13 |
14 - 2 |
fox 3:15 pm |
66033.0 |
Step 2: Select rows where 'opponent' is 'new orleans saints'.
| week |
date |
opponent |
result |
record |
tv_time |
attendance |
| 7 |
2001-10-28 |
new orleans saints |
l 34 - 31 |
6 - 1 |
fox 12:00 pm |
66189.0 |
Step 3: Select rows where 'record' is '6 - 1'.
| week |
date |
opponent |
result |
record |
tv_time |
attendance |
| 7 |
2001-10-28 |
new orleans saints |
l 34 - 31 |
6 - 1 |
fox 12:00 pm |
66189.0 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| week |
date |
opponent |
result |
record |
tv_time |
attendance |
| 7 |
2001-10-28 |
new orleans saints |
l 34 - 31 |
6 - 1 |
fox 12:00 pm |
66189.0 |
Prediction: TRUE
Ground-truth: TRUE