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
are the wins for finland more/less than their losses at home ?
VBD-AUX DT NNS IN NNP NNP IN PRP$ NNS IN NN .
more
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.String Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.String Keyword
select ( select count ( * ) from w where c7 = 'win' and c3 = 'finland' ) > ( select count ( * ) from w where c7 = 'loss' and c3 = 'finland' )
None None Column None Literal Keyword None None Column None Column None
c7 ['agg', 'agg_count'] c7 c3