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
in what year did they score the least amount of goals ?
IN WDT NN VBD-AUX PRP VBP DT JJS NN IN NNS .
1991
Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword
select c1_number from w group by c1_number order by sum ( c6_number1 ) limit 1
None None Column None None Column Keyword Keyword Keyword Keyword Column None
c1_number c6_number1 ['sort', '_group'] ['sort', '_group'] ['sort', '_group'] ['sort', '_group'] c6_number1