Step 1: Select rows where the 'date' is '01-02-12' or '9999-02-20'.
date |
visitor |
score |
home |
decision |
attendance |
record |
01-02-9999 |
minnesota |
4 - 1 |
columbus |
backstrom |
18529 |
30 - 19 - 3 |
9999-02-05 |
detroit |
3 - 2 |
minnesota |
backstrom |
18568 |
30 - 19 - 4 |
01-02-07 |
dallas |
1 - 0 |
minnesota |
backstrom |
18568 |
30 - 20 - 4 |
9999-02-09 |
ny islanders |
3 - 4 |
minnesota |
backstrom |
18568 |
31 - 20 - 4 |
01-02-10 |
minnesota |
2 - 1 |
st louis |
harding |
16477 |
32 - 20 - 4 |
01-02-12 |
minnesota |
2 - 4 |
edmonton |
harding |
16839 |
32 - 21 - 4 |
01-02-14 |
minnesota |
5 - 4 |
vancouver |
backstrom |
18630 |
33 - 21 - 4 |
9999-02-17 |
nashville |
4 - 5 |
minnesota |
backstrom |
18568 |
34 - 21 - 4 |
9999-02-19 |
vancouver |
3 - 2 |
minnesota |
backstrom |
18568 |
34 - 21 - 5 |
9999-02-20 |
minnesota |
0 - 3 |
chicago |
harding |
17812 |
34 - 22 - 5 |
9999-02-24 |
calgary |
2 - 1 |
minnesota |
backstrom |
18568 |
34 - 23 - 5 |
9999-02-26 |
minnesota |
1 - 4 |
washington |
backstrom |
17391 |
34 - 24 - 5 |
9999-02-27 |
minnesota |
3 - 2 |
tampa bay |
backstrom |
17211 |
35 - 24 - 5 |
9999-02-29 |
minnesota |
3 - 2 |
florida |
backstrom |
16927 |
36 - 24 - 5 |
Step 2: Select rows where the 'score' is '2 - 4' or '0 - 3'.
date |
visitor |
score |
home |
decision |
attendance |
record |
01-02-12 |
minnesota |
2 - 4 |
edmonton |
harding |
16839 |
32 - 21 - 4 |
9999-02-20 |
minnesota |
0 - 3 |
chicago |
harding |
17812 |
34 - 22 - 5 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 2, otherwise return FALSE.
date |
visitor |
score |
home |
decision |
attendance |
record |
01-02-12 |
minnesota |
2 - 4 |
edmonton |
harding |
16839 |
32 - 21 - 4 |
9999-02-20 |
minnesota |
0 - 3 |
chicago |
harding |
17812 |
34 - 22 - 5 |