canal length (miles) locks max length (ft) width (ft) year opened year abandoned year restored
canal
length -lrb- miles -rrb-
locks
max length -lrb- ft -rrb-
width -lrb- ft -rrb-
year opened
year abandoned
year restored
number
number
number
number
number
number
number
text number number number number number number number
aberdeenshire canal 18 18 150 35 1805 1854 2002
how many canals are longer than thirty miles ?
WRB JJ NNS VBD-AUX JJR IN CD NNS .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c1 ) from w where c2_number > 30
Keyword Keyword Column None Column Keyword Literal None None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 c2_number ['comp', 'comp_greater']