date racecourse distance race status race position winning distance (lengths) jockey rating going odds prize money
date
racecourse
distance
race status
race
position
winning distance -lrb- lengths -rrb-
jockey
rating
going
odds
prize money
number parsed year month day
number
number
number
number number1 number2
number
date text text text text rank number text number text fraction unitnum
april 10, 2004 kempton park 8f listed snowdrop fillies stakes 2nd to beneventa 6 johnny murtagh 114 good to soft 4/11f £6,600
previous to july 6 , 2004 what is the highest prize money ?
JJ TO NNP CD , CD WP VBD-AUX DT JJS NN NN .
£56,760.56
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword
select max ( c12_number ) from w where id < ( select id from w where c1 = 'july 6, 2004' )
Keyword Keyword Literal Literal Literal Literal None None Keyword Keyword Column Column None
['comp', ''] ['comp', ''] ['max', 'max_max'] ['max', 'max_max'] c12_number c12_number