Step 1: Select rows where 'wins' is greater than 0.
year |
tournaments_played |
cuts_made |
wins |
best_finish |
earnings |
money_list_rank |
1998 |
3 |
2 |
0 |
t - 23 |
37221 |
221 |
2000 |
29 |
14 |
0 |
t - 17 |
143248 |
179 |
2001 |
2 |
0 |
0 |
cut |
0 |
n / a |
2002 |
3 |
0 |
0 |
cut |
0 |
n / a |
2003 |
1 |
0 |
0 |
cut |
0 |
n / a |
2004 |
2 |
2 |
0 |
t - 69 |
15858 |
n / a |
2005 |
1 |
1 |
0 |
t - 65 |
10547 |
n / a |
Step 2: Use a `CASE` statement to return FALSE if the number of rows is greater than or equal to 1, otherwise return TRUE.
year |
tournaments_played |
cuts_made |
wins |
best_finish |
earnings |
money_list_rank |