club town founded nickname colours home ground titles website
club
town
founded
nickname
colours
home ground
titles
website
number
list length
number
text text number text <t, text> text number text
churchill united churchill 1969 rams silver & red hazelwood south reserve 4
how many teams have the color red in their team colors ?
WRB JJ NNS VBD-AUX DT NN NN IN PRP$ NN NNS .
2
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c1 ) from w where c5_list = 'red'
Keyword Keyword Column None None Column Literal None None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c1 c5_list