date time opponent site tv result attendance record
date
time
opponent
site
tv
result
attendance
record
number parsed year month day
number hour min
raw home
first second first_address
result number number1 number2
number
first second first_number first_number1 first_number2 second_number second_number1 second_number2
date time text address(text) text score number score(score)
11/09/2013 1:00 pm trinity baptist pan american center • las cruces, nm
(colorado state challenge) espn3 w 91-74 409 2-9 (0-1)
how many teams had at most an attendance of 1,000 ?
WRB JJ NNS VBD-AUX IN RBS DT NN IN CD .
6
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c3 ) from w where c7_number <= 1000
Keyword Keyword Column None Keyword Keyword None Column None Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c3 ['comp', 'comp_lequal'] ['comp', 'comp_lequal'] c7_number