outcome no. date tournament surface opponent score
outcome
no .
date
tournament
surface
opponent
score
number
number parsed year month day
list length list_first list_second list_first_number list_first_number1 list_first_number2 list_second_number list_second_number1 list_second_number2
text number date text text text <c,score(score)>
runner-up 1 1 august 2011 sao paulo, brazil clay maria fernanda alves 6-4, 5-7, 3-6
how many times was the surface clay ?
WRB JJ NNS VBD-AUX DT NN NN .
5
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c5 = 'clay'
Keyword Keyword Keyword None None Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c5