Step 1: Select rows where the years are 1990 and 1999.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
grand slam tournaments |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
french open |
a |
qf |
qf |
3r |
3r |
qf |
qf |
1r |
qf |
qf |
2r |
3r |
1r |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
us open |
1r |
2r |
3r |
3r |
qf |
a |
3r |
qf |
3r |
2r |
3r |
2r |
1r |
Step 2: Select rows where the results in the years 1990 and 1999 are the same for each tournament.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
australian open |
a |
3r |
3r |
3r |
a |
qf |
3r |
2r |
1r |
a |
2r |
1r |
1r |
french open |
a |
qf |
qf |
3r |
3r |
qf |
qf |
1r |
qf |
qf |
2r |
3r |
1r |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
us open |
1r |
2r |
3r |
3r |
qf |
a |
3r |
qf |
3r |
2r |
3r |
2r |
1r |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of tournaments, otherwise return FALSE.
tournament |
c_1986 |
c_1988 |
c_1989 |
c_1990 |
c_1991 |
c_1992 |
c_1993 |
c_1994 |
c_1995 |
c_1996 |
c_1997 |
c_1998 |
c_1999 |
Prediction: TRUE
Ground-truth: FALSE