Step 1: Select rows where 'champion' is 'se ri pak'.
year |
dates |
venue |
champion |
country |
score |
to_par |
margin_of_victory |
runner__s____up |
purse |
winner__s_share |
2013 |
9999-08-01 |
old course at st andrews |
stacy lewis |
united states |
280 |
- 8 |
2 strokes |
na yeon choi hee young park |
2750000 |
402583 |
2012 |
9999-09-13 |
royal liverpool golf club |
jiyai shin |
south korea |
279 |
- 9 |
9 strokes |
inbee park |
2750000 |
428650 |
2011 |
9999-07-28 |
carnoustie golf links |
yani tseng |
taiwan |
272 |
- 16 |
4 strokes |
brittany lang |
2500000 |
392133 |
2010 |
9999-07-29 - 9999-08-01 |
royal birkdale golf club |
yani tseng |
taiwan |
277 |
- 11 |
1 stroke |
katherine hull |
2500000 |
408714 |
2009 |
9999-07-30 - 9999-08-02 |
royal lytham & st annes golf club |
catriona matthew |
scotland |
285 |
- 3 |
3 strokes |
karrie webb |
2200000 |
335000 |
2008 |
9999-07-31 - 9999-08-03 |
sunningdale golf club |
jiyai shin |
south korea |
270 |
- 18 |
3 strokes |
yani tseng |
2100000 |
314464 |
2007 |
9999-08-02 |
old course at st andrews |
lorena ochoa |
mexico |
287 |
- 5 |
4 strokes |
maria hjorth jee young lee |
2000000 |
320512 |
2006 |
9999-08-03 |
royal lytham & st annes golf club |
sherri steinhauer |
united states |
281 |
- 7 |
3 strokes |
sophie gustafson cristie kerr |
1800000 |
305440 |
2005 |
9999-07-28 |
royal birkdale golf club |
jeong jang |
south korea |
272 |
- 16 |
4 strokes |
sophie gustafson |
1800000 |
280208 |
2004 |
9999-07-29 - 9999-08-01 |
sunningdale golf club |
karen stupples |
england |
269 |
- 19 |
5 strokes |
rachel hetherington |
1600000 |
290880 |
2003 |
9999-07-31 - 9999-08-03 |
royal lytham & st annes golf club |
annika sörenstam |
sweden |
278 |
- 10 |
1 stroke |
se ri pak |
1600000 |
254880 |
2002 |
9999-08-08 |
turnberry - ailsa course |
karrie webb |
australia |
273 |
- 15 |
2 strokes |
michelle ellis paula martà |
1500000 |
236383 |
2001 |
9999-08-02 |
sunningdale golf club |
se ri pak |
south korea |
277 |
- 11 |
2 strokes |
mi hyun kim |
1500000 |
221650 |
Step 2: Select rows where 'year' is 2003.
year |
dates |
venue |
champion |
country |
score |
to_par |
margin_of_victory |
runner__s____up |
purse |
winner__s_share |
2001 |
9999-08-02 |
sunningdale golf club |
se ri pak |
south korea |
277 |
- 11 |
2 strokes |
mi hyun kim |
1500000 |
221650 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
dates |
venue |
champion |
country |
score |
to_par |
margin_of_victory |
runner__s____up |
purse |
winner__s_share |
Final output table:
verification_result |
FALSE |
Prediction: FALSE