Step 1: Select rows where 'date' is '2004-10-10'.
date |
tournament |
surface |
opponent |
score |
1996-01-14 |
auckland , new zealand |
hard |
brett steven |
6 - 4 , 6 - 4 |
1998-11-01 |
mexico city , mexico |
clay |
xavier malisse |
6 - 3 , 6 - 3 |
2001-05-06 |
munich , germany |
clay |
antony dupuis |
6 - 4 , 7 - 5 |
2001-07-15 |
gstaad , switzerland |
clay |
juan carlos ferrero |
6 - 1 , 6 - 7 (5 - 7) , 7 - 5 |
2003-07-13 |
gstaad , switzerland |
clay |
roger federer |
5 - 7 , 6 - 3 , 6 - 3 , 1 - 6 , 6 - 3 |
2004-10-10 |
tokyo , japan |
hard |
taylor dent |
5 - 7 , 6 - 1 , 6 - 3 |
2004-11-03 |
basel , switzerland |
carpet (i) |
david nalbandian |
5 - 7 , 6 - 3 , 6 - 4 , 1 - 6 , 6 - 2 |
Step 2: Select rows where 'surface' is 'hard'.
date |
tournament |
surface |
opponent |
score |
2004-10-10 |
tokyo , japan |
hard |
taylor dent |
5 - 7 , 6 - 1 , 6 - 3 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
tournament |
surface |
opponent |
score |
2004-10-10 |
tokyo , japan |
hard |
taylor dent |
5 - 7 , 6 - 1 , 6 - 3 |
Prediction: TRUE