# 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
for how many games was attendance above 40,000 ?
IN WRB JJ NNS VBD-AUX NN IN CD .
3
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( * ) from w where c8_number > 40000
None Keyword Keyword None None Column Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c8_number ['comp', 'comp_greater']