# player span caps total caps win %
#
player
span
caps
total caps
win %
number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number
number
number
number text timespan number number percentage
1 fabien pelous 1997-2006 42 118 64.28%
how many players have spans above three years ?
WRB JJ NNS VBD-AUX NNS IN CD NNS .
6
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3_maximum_year - c3_minimum_year > 3
Keyword Keyword Column None Column Keyword Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c3_minimum_year ['comp', 'comp_greater'] c3_minimum_year