Step 1: Order the table by 'earnings' in ascending order.
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: Select row number 1.
year |
tournaments_played |
cuts_made |
wins |
best_finish |
earnings |
money_list_rank |
2001 |
2 |
0 |
0 |
cut |
0 |
n / a |
2002 |
3 |
0 |
0 |
cut |
0 |
n / a |
2003 |
1 |
0 |
0 |
cut |
0 |
n / a |
2005 |
1 |
1 |
0 |
t - 65 |
10547 |
n / a |
2004 |
2 |
2 |
0 |
t - 69 |
15858 |
n / a |
1998 |
3 |
2 |
0 |
t - 23 |
37221 |
221 |
2000 |
29 |
14 |
0 |
t - 17 |
143248 |
179 |
Step 3: Select rows where 'earnings' is 0.
year |
tournaments_played |
cuts_made |
wins |
best_finish |
earnings |
money_list_rank |
2001 |
2 |
0 |
0 |
cut |
0 |
n / a |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
tournaments_played |
cuts_made |
wins |
best_finish |
earnings |
money_list_rank |
2001 |
2 |
0 |
0 |
cut |
0 |
n / a |