no. date location surface opponent in final score
no .
date
location
surface
opponent in final
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
number date text text text <w,score(number)>
1 28 august 2000 spoleto, italy $10,000 clay maret ani 6-2 7-6(7)
how many matches were not played on a clay surface ?
WRB JJ NNS VBD-AUX RB VBN IN DT NN NN .
4
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c4 != 'clay'
Keyword Keyword None None Keyword None None None Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['comp', 'comp_not'] c4