date venue opponent score result competition #
date
venue
opponent
score
result
competition
#
number parsed year month day
address
number number1 number2
number number1 number2
number
date address text score score text number
15 nov 2006 lansdowne road, dublin san marino 2-0 5-0 euro 2008 qualifying 1
what is the number of times `` friendly '' appears as a competition ?
WP VBD-AUX DT NN IN NNS `` JJ '' VBZ IN DT NN .
3
select count ( * ) from w where c6 = 'friendly'