outcome no. date championship surface partner opponents in the final score in the final
outcome
no .
date
championship
surface
partner
opponents in the final
score in the final
number
number
address
first second
list length
list length list_number list_number1 list_number2
text number number address text(text) text <n,text> <c,score>
winner 1 1968 wimbledon, london hard (i) john newcombe ken rosewall
fred stolle 3-6, 8-6, 5-7, 14-12, 6-3
what is the number of titles in which the surface played on was carpet ?
WP VBD-AUX DT NN IN NNS IN WDT DT NN VBN IN VBD-AUX NN .
9
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c5 = 'carpet'
None None None Keyword Keyword None None None None Column None None None Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c5