no. name term of office president(s) served under
no .
name
term of office
president -lrb- s -rrb- served under
number
minimum_number minimum_parsed minimum_day minimum_month minimum_year maximum_number maximum_parsed maximum_day maximum_month maximum_year
number text timespan text
1 william bennett march 28, 1991 - january 20, 1993 george h. w. bush
what were the number of directors that stayed in office more than three years ?
WP VBD-AUX DT NN IN NNS WDT VBD IN NN RBR IN CD NNS .
3
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
None None Keyword Keyword Keyword Column None Column Column Column Keyword Keyword Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c2 c3_minimum_year c3_minimum_year c3_minimum_year ['comp', 'comp_greater'] ['comp', 'comp_greater'] c3_minimum_year