outcome year championship surface opponent score
outcome
year
championship
surface
opponent
score
number
first second second_number
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 text(number) text text <c, score(score)>
runner-up 2002 canada (toronto) (1) hard guillermo canas 4-6, 5-7
how many consecutive years was there a hard surface at the championship ?
WRB JJ JJ NNS VBD-AUX EX DT JJ NN IN DT NN .
9
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c2 ) from w where c4 = 'hard'
Keyword Keyword None Column None None None Literal Column None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c4