goal date location opponent lineup min assist/pass score result competition
goal
date
location
opponent
lineup
min
assist\\/pass
score
result
competition
number
number parsed year month day
number
number number1 number2
number number1 number2
number date text text text number text score score text
1 may 9, 2004 usaalbuquerque nm mexico on 70' (off lilly) 19 tarpley 3-0 3-0 friendly
how many total goals were scored against nigeria ?
WRB JJ JJ NNS VBD-AUX VBN IN NNP .
1
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c1 ) from w where c4 = 'nigeria'
Keyword Keyword Keyword Column None None Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c1 c4