# date venue opponent score result competition
#
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
result
number date address text score score text
1 1995-08-06 kyoto, japan costa rica 3-0 won friendly
what is the number of wins ?
WP VBD-AUX DT NN IN NNS .
9
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c6 = 'won'
None None None Keyword Keyword Literal None
['agg', 'agg_count'] ['agg', 'agg_count']