Step 1: Select rows where 'points' is 63.
| game |
march |
opponent |
score |
record |
points |
| 63 |
9999-01-04 |
detroit red wings |
2 - 2 |
24 - 28 - 11 |
59 |
| 64 |
9999-01-06 |
california golden seals |
4 - 4 |
24 - 28 - 12 |
60 |
| 65 |
9999-01-07 |
minnesota north stars |
1 - 3 |
24 - 29 - 12 |
60 |
| 66 |
9999-01-10 |
pittsburgh penguins |
2 - 2 |
24 - 29 - 13 |
61 |
| 67 |
9999-01-12 |
new york rangers |
2 - 7 |
24 - 30 - 13 |
61 |
| 68 |
9999-01-13 |
toronto maple leafs |
3 - 2 |
25 - 30 - 13 |
63 |
| 69 |
9999-01-18 |
new york rangers |
2 - 1 |
26 - 30 - 13 |
65 |
| 70 |
9999-01-20 |
boston bruins |
3 - 5 |
26 - 31 - 13 |
65 |
| 71 |
9999-01-21 |
toronto maple leafs |
1 - 1 |
26 - 31 - 14 |
66 |
| 72 |
9999-01-24 |
montreal canadiens |
3 - 5 |
26 - 32 - 14 |
66 |
| 73 |
9999-01-25 |
minnesota north stars |
2 - 2 |
26 - 32 - 15 |
67 |
| 74 |
9999-01-27 |
chicago black hawks |
1 - 3 |
26 - 33 - 15 |
67 |
| 75 |
9999-01-28 |
pittsburgh penguins |
3 - 1 |
27 - 33 - 15 |
69 |
Step 2: Select rows where 'opponent' is 'toronto maple leafs'.
| game |
march |
opponent |
score |
record |
points |
| 68 |
9999-01-13 |
toronto maple leafs |
3 - 2 |
25 - 30 - 13 |
63 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| game |
march |
opponent |
score |
record |
points |
| 68 |
9999-01-13 |
toronto maple leafs |
3 - 2 |
25 - 30 - 13 |
63 |
Prediction: TRUE