Step 1: Select rows where 'tournament' is 'cardiff , great britain'.
date |
tournament |
surface |
opponent_in_the_final |
score |
2003-06-02 |
surbiton , great britain |
grass |
wesley moodie |
4 - 6 , 7 - 6 (2) , 1 - 6 |
2004-04-26 |
glasgow , great britain f1 |
carpet |
gaël monfils |
4 - 6 , 3 - 6 |
2004-07-05 |
nottingham , great britain |
grass |
jo - wilfried tsonga |
3 - 6 , 4 - 6 |
2006-10-02 |
mons , belgium |
hard |
janko tipsarević |
4 - 6 , 6 - 1 , 2 - 6 |
2007-04-16 |
cardiff , great britain |
hard |
frédéric niemeyer |
4 - 6 , 5 - 7 |
2011-04-04 |
little rock , ar , usa f9 |
hard |
arnau brugués - davi |
3 - 6 , 1 - 6 |
2012-09-24 |
irvine , ca , usa f26 |
hard |
daniel nguyen |
5 - 7 , 2 - 6 |
2013-04-08 |
oklahoma city , usa f9 |
hard |
rik de voest |
3 - 6 , 2 - 6 |
Step 2: Select rows where 'date' is '2007-04-16'.
date |
tournament |
surface |
opponent_in_the_final |
score |
2007-04-16 |
cardiff , great britain |
hard |
frédéric niemeyer |
4 - 6 , 5 - 7 |
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_in_the_final |
score |
2007-04-16 |
cardiff , great britain |
hard |
frédéric niemeyer |
4 - 6 , 5 - 7 |
Prediction: TRUE
Ground-truth: TRUE