Step 1: Order the table by the 'events' column in descending order.
| tournament |
wins |
top___5 |
top___25 |
events |
cuts_made |
| masters tournament |
0 |
0 |
0 |
2 |
1 |
| us open |
0 |
0 |
1 |
2 |
1 |
| the open championship |
0 |
1 |
2 |
7 |
4 |
| pga championship |
0 |
0 |
0 |
6 |
4 |
| totals |
0 |
1 |
3 |
17 |
10 |
Step 2: Select row number 1.
| tournament |
wins |
top___5 |
top___25 |
events |
cuts_made |
| totals |
0 |
1 |
3 |
17 |
10 |
| the open championship |
0 |
1 |
2 |
7 |
4 |
| pga championship |
0 |
0 |
0 |
6 |
4 |
| masters tournament |
0 |
0 |
0 |
2 |
1 |
| us open |
0 |
0 |
1 |
2 |
1 |
Step 3: Select rows where the 'tournament' is 'the open championship'.
| tournament |
wins |
top___5 |
top___25 |
events |
cuts_made |
| totals |
0 |
1 |
3 |
17 |
10 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| tournament |
wins |
top___5 |
top___25 |
events |
cuts_made |