no. date home team visiting team goals score result venue competition
no .
date
home team
visiting team
goals
score
result
venue
competition
number
number parsed year month day
number number1 number2
result
address
number date text text text score score address text
1 16 may 1991 finland malta 87' 2-0 2-0 win helsinki olympic stadium uefa euro 1992 qualifying
how many losses did finland obtain ?
WRB JJ NNS VBD-AUX NNP VB .
6
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c7 = 'loss'
Keyword Keyword Column None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] c7