year competition date location opponent score result bye
year
competition
date
location
opponent
score
result
bye
number
minimum_number minimum_parsed minimum_day minimum_month minimum_year maximum_number maximum_parsed maximum_day maximum_month maximum_year
first second
number number1 number2
result
number text timespan text(text) text score score text
1990 world group, 1st round 2-4 feb barcelona (esp) spain 3-2 win
did austria win more games in 1992 or 1996 ?
VBD-AUX NNP VB JJR NNS IN CD CC CD .
1992
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Literal.Number Keyword Literal.Number Keyword Keyword Column Keyword Literal.String Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword
select c1_number from w where c1_number in ( 1992 , 1996 ) and c7_result = 'win' group by c1_number order by count ( * ) desc limit 1
None None Column Keyword None Column Literal Keyword Literal None
c7_result ['sort', 'sort_desc_group_count'] c1_number ['conj', 'conj_or']