# date venue opponent result competition scored
#
date
venue
opponent
result
competition
scored
number
number parsed year month day
address
number number1 number2
number
number date address text score text number
1 5 march 2002 lagos sweden 3-6 algarve cup 1
how many times does `` friendly '' appear in the competition column ?
WRB JJ NNS VBD-AUX `` JJ '' VB IN DT NN NN .
5
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c6 = 'friendly'
Keyword Keyword Keyword None None Literal None None None None Column None None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c6