goal date venue opponent score result competition
goal
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
number number1 number2
number date address text score score text
1 10 october 1998 tyencastle park, edinburgh estonia 1-1 3-2 ecqg9
what was the only opponent that had a result of 4-0 ?
WP VBD-AUX DT JJ NN WDT VBD-AUX DT NN IN JJ .
San Marino
Keyword Column Keyword Keyword Keyword Column Keyword Literal.String
select c4 from w where c6 = '4-0'
None None None None Column None None None Column None Literal None
c4 c6