name club position years current status international caps
name
club
position
years
current status
international caps
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number
text text text timespan text number
frank farina sydney fc fw 1982-83 coaching 67
how many players have above 40 international caps ?
WRB JJ NNS VBD-AUX IN CD JJ NNS .
15
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c1 ) from w where c6_number > 40
Keyword Keyword Column None Keyword Literal Column Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 ['comp', 'comp_greater'] c6_number c6_number