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
which opponent has the same score as san marino ?
WDT NN VBD-AUX DT JJ NN IN NNP NNP .
Andorra
select c3 from w where c3 != 'san marino' and c4 = ( select c4 from w where c3 = 'san marino' )