Step 1: Select rows where 'week' is 1.
week |
date |
opponent |
result |
game_site |
attendance |
1 |
1970-09-19 |
chicago bears |
l 24 - 16 |
yankee stadium |
62936 |
2 |
1970-09-27 |
dallas cowboys |
l 28 - 10 |
cotton bowl |
57236 |
3 |
1970-10-04 |
new orleans saints |
l 14 - 10 |
tulane stadium |
69126 |
4 |
1970-10-11 |
philadelphia eagles |
w 30 - 23 |
yankee stadium |
62820 |
5 |
1970-10-18 |
boston patriots |
w 16 - 0 |
harvard stadium |
39091 |
6 |
1970-10-25 |
st louis cardinals |
w 35 - 17 |
yankee stadium |
62984 |
7 |
1970-11-01 |
new york jets |
w 22 - 10 |
shea stadium |
63903 |
8 |
1970-11-08 |
dallas cowboys |
w 23 - 20 |
yankee stadium |
62938 |
9 |
1970-11-15 |
washington redskins |
w 35 - 33 |
yankee stadium |
62915 |
10 |
1970-11-23 |
philadelphia eagles |
l 23 - 20 |
franklin field |
59117 |
11 |
1970-11-29 |
washington redskins |
w 27 - 24 |
robert f kennedy memorial stadium |
50415 |
12 |
1970-12-06 |
buffalo bills |
w 20 - 6 |
yankee stadium |
62870 |
13 |
1970-12-13 |
st louis cardinals |
w 34 - 17 |
busch memorial stadium |
50845 |
14 |
1970-12-20 |
los angeles rams |
l 31 - 3 |
yankee stadium |
62870 |
Step 2: Select rows where 'attendance' is 62936.
week |
date |
opponent |
result |
game_site |
attendance |
1 |
1970-09-19 |
chicago bears |
l 24 - 16 |
yankee stadium |
62936 |
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 |
game_site |
attendance |
1 |
1970-09-19 |
chicago bears |
l 24 - 16 |
yankee stadium |
62936 |
Prediction: TRUE
Ground-truth: TRUE