Step 1: Select rows where 'player' is 'henrik stenson'.
place |
player |
country |
score |
to_par |
1 |
ben curtis |
united states |
73 + 67 + 68 = 208 |
- 2 |
t2 |
j b holmes |
united states |
71 + 68 + 70 = 209 |
- 1 |
t2 |
henrik stenson |
sweden |
71 + 70 + 68 = 209 |
- 1 |
t4 |
sergio garcía |
spain |
69 + 73 + 69 = 211 |
+ 1 |
t4 |
pádraig harrington |
ireland |
71 + 74 + 66 = 211 |
+ 1 |
t4 |
charlie wi |
south korea |
70 + 70 + 71 = 211 |
+ 1 |
t7 |
andrés romero |
argentina |
69 + 78 + 65 = 212 |
+ 2 |
t7 |
jeev milkha singh |
india |
68 + 74 + 70 = 212 |
+ 2 |
t9 |
aaron baddeley |
australia |
71 + 71 + 71 = 213 |
+ 3 |
t9 |
steve flesch |
united states |
73 + 70 + 70 = 213 |
+ 3 |
t9 |
david toms |
united states |
72 + 69 + 72 = 213 |
+ 3 |
t9 |
camilo villegas |
colombia |
74 + 72 = 67 = 213 |
+ 3 |
Step 2: Select rows where 'player' is 'aaron baddeley'.
place |
player |
country |
score |
to_par |
t2 |
henrik stenson |
sweden |
71 + 70 + 68 = 209 |
- 1 |
Step 3: Select rows where 'player' is 'charlie wi'.
place |
player |
country |
score |
to_par |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1 for each player, otherwise return FALSE.
place |
player |
country |
score |
to_par |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: TRUE