Step 1: f_select_row(row 3, row 10)
year |
dates |
venue |
champion |
country |
score |
to par |
margin of victory |
runner (s) - up |
purse |
winner 's share |
2013 |
aug 1 - 4 |
old course at st andrews |
stacy lewis |
united states |
280 |
- 8 |
2 strokes |
na yeon choi hee young park |
2750000 |
402583 |
2012 |
sep 13 - 16 |
royal liverpool golf club |
jiyai shin |
south korea |
279 |
- 9 |
9 strokes |
inbee park |
2750000 |
428650 |
2011 |
july 28 - 31 |
carnoustie golf links |
yani tseng |
taiwan |
272 |
- 16 |
4 strokes |
brittany lang |
2500000 |
392133 |
2010 |
july 29 - aug 1 |
royal birkdale golf club |
yani tseng |
taiwan |
277 |
- 11 |
1 stroke |
katherine hull |
2500000 |
408714 |
2009 |
july 30 - aug 2 |
royal lytham & st annes golf club |
catriona matthew |
scotland |
285 |
- 3 |
3 strokes |
karrie webb |
2200000 |
335000 |
2008 |
july 31 - aug 3 |
sunningdale golf club |
jiyai shin |
south korea |
270 |
- 18 |
3 strokes |
yani tseng |
2100000 |
314464 |
2007 |
aug 2 - 5 |
old course at st andrews |
lorena ochoa |
mexico |
287 |
- 5 |
4 strokes |
maria hjorth jee young lee |
2000000 |
320512 |
2006 |
aug 3 - 6 |
royal lytham & st annes golf club |
sherri steinhauer |
united states |
281 |
- 7 |
3 strokes |
sophie gustafson cristie kerr |
1800000 |
305440 |
2005 |
july 28 - 31 |
royal birkdale golf club |
jeong jang |
south korea |
272 |
- 16 |
4 strokes |
sophie gustafson |
1800000 |
280208 |
2004 |
july 29 - aug 1 |
sunningdale golf club |
karen stupples |
england |
269 |
- 19 |
5 strokes |
rachel hetherington |
1600000 |
290880 |
2003 |
july 31 - aug 3 |
royal lytham & st annes golf club |
annika sörenstam |
sweden |
278 |
- 10 |
1 stroke |
se ri pak |
1600000 |
254880 |
2002 |
aug 8 - 11 |
turnberry - ailsa course |
karrie webb |
australia |
273 |
- 15 |
2 strokes |
michelle ellis paula martí |
1500000 |
236383 |
2001 |
aug 2 - 5 |
sunningdale golf club |
se ri pak |
south korea |
277 |
- 11 |
2 strokes |
mi hyun kim |
1500000 |
221650 |
Step 2: f_select_column(champion, score)
year |
dates |
venue |
champion |
country |
score |
to par |
margin of victory |
runner (s) - up |
purse |
winner 's share |
2010 |
july 29 - aug 1 |
royal birkdale golf club |
yani tseng |
taiwan |
277 |
- 11 |
1 stroke |
katherine hull |
2500000 |
408714 |
2003 |
july 31 - aug 3 |
royal lytham & st annes golf club |
annika sörenstam |
sweden |
278 |
- 10 |
1 stroke |
se ri pak |
1600000 |
254880 |
Step 3: simple_query()
champion |
score |
yani tseng |
277 |
annika sörenstam |
278 |
Prompting LLM for the final answer... >>>