outcome no. date tournament surface partner opponents score
outcome
no .
date
tournament
surface
partner
opponents
score
number
number parsed year month day
first second
list length
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) text <n,text> <c,score(score)>
winner 1 april 18, 2004 jackson, united states hard (i) alisa kleybanova cory ann avants
kristen schlukebir 6-2, 6-3
what are the number of times hard appears as the surface ?
WP VBD-AUX DT NN IN NNS JJ VBZ IN DT NN .
12
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c5_first = 'hard'
None None Keyword Keyword Keyword Keyword Literal None None None Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c5_first