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
how many times was andorra the opponent ?
WRB JJ NNS VBD-AUX NNP DT NN .
2
select count ( * ) from w where c3 = 'andorra'