Step 1: Select rows where 'opponent' is 'new orleans saints'.
| week |
date |
opponent |
result |
tv_time |
attendance |
| 1 |
1997-08-31 |
tennessee oilers |
l 24 - 21 |
nbc 10:00 am |
30171 |
| 2 |
1997-09-08 |
kansas city chiefs |
l 28 - 27 |
abc 6:00 pm |
61523 |
| 3 |
1997-09-14 |
atlanta falcons |
w 36 - 31 |
nbc 10:00 am |
47922 |
| 4 |
1997-09-21 |
new york jets |
l 23 - 22 |
nbc 10:00 am |
72586 |
| 5 |
1997-09-28 |
st louis rams |
w 35 - 17 |
fox 1:15 pm |
42506 |
| 6 |
1997-10-05 |
san diego chargers |
l 25 - 10 |
nbc 1:15 pm |
43648 |
| 8 |
1997-10-19 |
denver broncos |
w 28 - 25 |
nbc 1:15 pm |
57006 |
| 9 |
1997-10-26 |
seattle seahawks |
l 45 - 34 |
nbc 1:15 pm |
66264 |
| 10 |
1997-11-02 |
carolina panthers |
l 38 - 14 |
nbc 10:00 am |
71064 |
| 11 |
1997-11-09 |
new orleans saints |
l 13 - 10 |
fox 1:15 pm |
40091 |
| 12 |
1997-11-16 |
san diego chargers |
w 38 - 13 |
nbc 1:15 pm |
65714 |
| 13 |
1997-11-24 |
denver broncos |
l 31 - 3 |
abc 6:00 pm |
75307 |
| 14 |
1997-11-30 |
miami dolphins |
l 34 - 16 |
nbc 1:15 pm |
50569 |
| 15 |
1997-12-07 |
kansas city chiefs |
l 30 - 0 |
nbc 10:00 am |
76379 |
| 16 |
1997-12-14 |
seattle seahawks |
l 22 - 21 |
nbc 1:15 pm |
40124 |
| 17 |
1997-12-21 |
jacksonville jaguars |
l 20 - 9 |
nbc 1:15 pm |
40032 |
Step 2: Select rows where 'attendance' is the minimum value in the 'attendance' column.
| week |
date |
opponent |
result |
tv_time |
attendance |
| 11 |
1997-11-09 |
new orleans saints |
l 13 - 10 |
fox 1:15 pm |
40091 |
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 |
tv_time |
attendance |
| 11 |
1997-11-09 |
new orleans saints |
l 13 - 10 |
fox 1:15 pm |
40091 |
Prediction: TRUE