school team name town county enrollment (2010-11 & 2011-12) primary mshsaa class* football class
school
team name
town
county
enrollment -lrb- 2010-11 & 2011 -- 12 -rrb-
primary mshsaa class \\*
football class
first second
number
number
number
text(text) text text text number number number
chillicothe high school (missouri) (lady) cardinals st. joseph buchanan 846 4 4
how many of the schools had at least 500 students enrolled in the 2010-2011 and 2011-2012 season ?
WRB JJ IN DT NNS VBD-AUX IN JJS CD NNS VBN IN DT CD CC CD NN .
6
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c5_number >= 500
Keyword Keyword None None Column None Keyword Keyword Literal None Column Column Column Column Column Column Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] c5_number c5_number c5_number c5_number c5_number c5_number c5_number