# date opponent score win loss save crowd record
#
date
opponent
score
win
loss
save
crowd
record
number
number parsed year month day
raw home
first second first_result first_number first_number1 first_number2 second_number
number
number number1 number2
number date text score(number) text text text number score
1 apr 3 @min w 4-3 (10) morris williams hernandez 34381 1-0
before april 7 , how many times had morris won ?
IN NNP CD , WRB JJ NNS VBD-AUX NNP NNP .
1
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c2_parsed < ( select c2_parsed from w where c2 = 'apr 7' ) and c5 = 'morris'
Column Literal Literal None Keyword Keyword Keyword None Literal Column None
c2_parsed ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c5