name title reign title recognition successful defenses
name
title reign
title recognition
successful defenses
number
number year month week day
list length list_first list_second
number
number text time <c, text(text)> number
1 joe calzaghe 4 years, 6 months, 3 weeks and 1 day ibf, wba, wbo, wbc, the ring 21
what is the number of times the title reign was longer than 3 years ?
WP VBD-AUX DT NN IN NNS DT NN NN VBD-AUX JJR IN CD NNS .
9
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( * ) from w where c3_year >= 3
None None Keyword Keyword Keyword Keyword None Column Column None Keyword Keyword Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c3_year c3_year ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] c3_year