# date opponent score win loss save attendance record
#
date
opponent
score
win
loss
save
attendance
record
number
number parsed year month day
first second first_number first_number1 first_number2 second_number
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(number) text(score) text(score) text(number) number score
106 august 2 pirates 3-4 (11) rick white (4-5) bobby munoz (7-4) dan miceli (2) 40164 51-55
how many different opponents were played after august 4 ?
WRB JJ JJ NNS VBD-AUX VBN IN NNP CD .
2
Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword
select count ( distinct c3 ) from w where id > ( select id from w where c2 = 'august 4' )
Keyword Keyword Keyword Column None None Keyword Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['conj', 'conj_or'] c3 ['comp', 'comp_greater']