outcome no. date tournament surface opponent in the final score
outcome
no .
date
tournament
surface
opponent in the final
score
number
number parsed year month day
list length list_first list_second list_first_number list_first_number1 list_first_number2 list_second_number list_second_number1 list_second_number2
text number date text text text <c, score(score)>
runner-up 1 2 september 2001 mostar clay adriana basaric 4-6, 3-6
what tournament was played before rimini on august 2002 ?
WDT NN VBD-AUX VBN IN NNP IN NNP CD .
Gorizia
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c4 from w where c3_parsed < ( select c3_parsed from w where c4 = 'rimini' ) order by c3_parsed desc limit 1
None Column None None Column Literal None None None None
c4 c3_parsed