Step 1: Select rows where 'outcome' is 'runner-up'.
outcome |
year |
championship |
surface |
opponent |
score |
runner - up |
2000-01-01 |
stuttgart |
hard (i) |
wayne ferreira |
6 - 7 (6 - 8) , 6 - 3 , 7 - 6 (7 - 5) , 6 - 7 (2 - 7) , 2 - 6 |
winner |
2002-01-01 |
indian wells |
hard |
tim henman |
6 - 1 , 6 - 2 |
runner - up |
2002-01-01 |
cincinnati |
hard |
carlos moyá |
5 - 7 , 6 - 7 (5 - 7) |
runner - up |
2002-01-01 |
paris |
carpet (i) |
marat safin |
6 - 7 (4 - 7) , 0 - 6 , 4 - 6 |
winner |
2003-01-01 |
indian wells (2) |
hard |
gustavo kuerten |
6 - 1 , 6 - 1 |
runner - up |
2004-01-01 |
cincinnati (2) |
hard |
andre agassi |
3 - 6 , 6 - 3 , 2 - 6 |
runner - up |
2005-01-01 |
indian wells |
hard |
roger federer |
2 - 6 , 4 - 6 , 4 - 6 |
Step 2: Select rows where 'opponent' is 'wayne ferreira'.
outcome |
year |
championship |
surface |
opponent |
score |
runner - up |
2000-01-01 |
stuttgart |
hard (i) |
wayne ferreira |
6 - 7 (6 - 8) , 6 - 3 , 7 - 6 (7 - 5) , 6 - 7 (2 - 7) , 2 - 6 |
runner - up |
2002-01-01 |
cincinnati |
hard |
carlos moyá |
5 - 7 , 6 - 7 (5 - 7) |
runner - up |
2002-01-01 |
paris |
carpet (i) |
marat safin |
6 - 7 (4 - 7) , 0 - 6 , 4 - 6 |
runner - up |
2004-01-01 |
cincinnati (2) |
hard |
andre agassi |
3 - 6 , 6 - 3 , 2 - 6 |
runner - up |
2005-01-01 |
indian wells |
hard |
roger federer |
2 - 6 , 4 - 6 , 4 - 6 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
outcome |
year |
championship |
surface |
opponent |
score |
runner - up |
2000-01-01 |
stuttgart |
hard (i) |
wayne ferreira |
6 - 7 (6 - 8) , 6 - 3 , 7 - 6 (7 - 5) , 6 - 7 (2 - 7) , 2 - 6 |
Prediction: TRUE