Step 1: Select rows where 'date' is '9999-09-30'.
year |
date |
winner |
result |
loser |
attendance |
location |
1950 |
9999-10-01 |
green bay packers |
31 - 21 |
chicago bears |
24893 |
green bay |
1950 |
01-10-15 |
chicago bears |
28 - 14 |
green bay packers |
51065 |
chicago |
1951 |
9999-09-30 |
chicago bears |
31 - 20 |
green bay packers |
24666 |
green bay |
1951 |
9999-11-18 |
chicago bears |
24 - 13 |
green bay packers |
36771 |
chicago |
1952 |
9999-09-28 |
chicago bears |
24 - 14 |
green bay packers |
24656 |
green bay |
1952 |
9999-11-09 |
green bay packers |
41 - 28 |
chicago bears |
41751 |
chicago |
1953 |
9999-10-04 |
chicago bears |
17 - 13 |
green bay packers |
24835 |
green bay |
1953 |
9999-11-08 |
chicago bears |
21 - 21 |
green bay packers |
39889 |
chicago |
1954 |
9999-10-03 |
chicago bears |
10 - 3 |
green bay packers |
24414 |
green bay |
1954 |
9999-11-07 |
chicago bears |
28 - 23 |
green bay packers |
47038 |
chicago |
1955 |
9999-10-02 |
green bay packers |
24 - 3 |
chicago bears |
24662 |
green bay |
1955 |
9999-11-06 |
chicago bears |
52 - 31 |
green bay packers |
48890 |
chicago |
1956 |
9999-10-07 |
chicago bears |
37 - 21 |
green bay packers |
24668 |
green bay |
1956 |
9999-11-11 |
chicago bears |
38 - 14 |
green bay packers |
49172 |
chicago |
1957 |
9999-09-29 |
green bay packers |
21 - 17 |
chicago bears |
32132 |
green bay |
1957 |
9999-11-10 |
chicago bears |
21 - 14 |
green bay packers |
47153 |
chicago |
1958 |
9999-09-28 |
chicago bears |
34 - 20 |
green bay packers |
32150 |
green bay |
1958 |
9999-11-09 |
chicago bears |
24 - 10 |
green bay packers |
48424 |
chicago |
1959 |
9999-09-27 |
green bay packers |
9 - 6 |
chicago bears |
32150 |
green bay |
1959 |
9999-11-08 |
chicago bears |
28 - 17 |
green bay packers |
46205 |
chicago |
Step 2: Select rows where 'winner' is 'chicago bears'.
year |
date |
winner |
result |
loser |
attendance |
location |
1951 |
9999-09-30 |
chicago bears |
31 - 20 |
green bay packers |
24666 |
green bay |
Step 3: Select rows where 'loser' is 'green bay packers'.
year |
date |
winner |
result |
loser |
attendance |
location |
1951 |
9999-09-30 |
chicago bears |
31 - 20 |
green bay packers |
24666 |
green bay |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
date |
winner |
result |
loser |
attendance |
location |
1951 |
9999-09-30 |
chicago bears |
31 - 20 |
green bay packers |
24666 |
green bay |
Prediction: TRUE