Step 1: Select rows where 'tournament' is 'wimbledon'.
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 'c_1986' is 'a' or 'c_1988' is 'a' or 'c_1989' is 'a' or 'c_1990' is 'a' or 'c_1991' is 'a' or 'c_1992' is 'a' or 'c_1993' is 'a' or 'c_1994' is 'a' or 'c_1995' is 'a' or 'c_1996' is 'a' or 'c_1997' is 'a' or 'c_1998' is 'a' or 'c_1999' is 'a'.
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 |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, 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 |
wimbledon |
a |
sf |
qf |
3r |
qf |
3r |
1r |
2r |
3r |
qf |
3r |
3r |
1r |
Prediction: TRUE