# date opponent score win loss save attendance record
#
date
opponent
score
win
loss
save
attendance
record
number
number parsed year month day
raw home
number number1 number2
first second second_number second_number1 second_number2
first second second_number second_number1 second_number2
first second second_number
number
number number1 number2
number date text score text(score) text(score) text(number) number score
79 july 1 @ braves 8-4 gonzalez (11-3) hudson (6-4) betancourt (14) 18796 45-32
how many games took place in july before the fourth of july ?
WRB JJ NNS VBD NN IN NNP IN DT JJ IN NNP .
2
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( * ) from w where c2_month = 7 and c2_day < 4
Keyword Keyword None None None Column Literal Keyword None Literal None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c2_month ['comp', '']