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
on how many dates was the outcome the same as on 1 august 2011
IN WRB JJ NNS VBD-AUX DT NN DT JJ IN IN CD NNP CD
2
select count ( c3 ) from w where c3 != '1 august 2011' and c1 = ( select c1 from w where c3 = '1 august 2011' )