name parentage size flower colour flower type
name
parentage
size
flower color
flower type
number
text text unitnum text text
cornish snow cuspidata × saluenensis 04.0m2 white single
how many flowers have the same type as the freedom bell ?
WRB JJ NNS VBD-AUX DT JJ NN IN DT NNP NNP .
4
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword
select count ( c1 ) from w where c1 != 'freedom bell' and c5 = ( select c5 from w where c1 = 'freedom bell' )
Keyword Keyword Column None None Keyword Column Keyword None Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 ['conj', 'conj_and'] c5 ['conj', 'conj_and']