peter vagenas
between his 2000 and 2012 seasons , peter vagenas scored an average of 1 goal per season .
{'scope': 'subset', 'col': '5', 'type': 'average', 'result': '1', 'subset': {'col': '1', 'criterion': 'greater_than_eq', 'value': '2000'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_greater_eq', 'args': ['all_rows', 'season', '2000'], 'result': None, 'ind': 0, 'tostr': 'filter_greater_eq { all_rows ; season ; 2000 }', 'tointer': 'select the rows whose season record is greater than or equal to 2000 .'}, 'goals'], 'result': '1', 'ind': 1, 'tostr': 'avg { filter_greater_eq { all_rows ; season ; 2000 } ; goals }'}, '1'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_greater_eq { all_rows ; season ; 2000 } ; goals } ; 1 } = true', 'tointer': 'select the rows whose season record is greater than or equal to 2000 . the average of the goals record of these rows is 1 .'}
round_eq { avg { filter_greater_eq { all_rows ; season ; 2000 } ; goals } ; 1 } = true
select the rows whose season record is greater than or equal to 2000 . the average of the goals record of these rows is 1 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_greater_eq_0': 'filter_greater_eq', 'all_rows_4': 'all_rows', 'season_5': 'season', '2000_6': '2000', 'goals_7': 'goals', '1_8': '1'}
['season', 'club', 'league', 'apps', 'goals']
[['2000', 'los angeles galaxy', 'major league soccer', '16', '3'], ['2001', 'los angeles galaxy', 'major league soccer', '26', '3'], ['2002', 'los angeles galaxy', 'major league soccer', '17', '0'], ['2003', 'los angeles galaxy', 'major league soccer', '20', '0'], ['2004', 'los angeles galaxy', 'major league soccer', '12', '0'], ['2005', 'los angeles galaxy', 'major league soccer', '29', '5'], ['2006', 'los angeles galaxy', 'major league soccer', '25', '2'], ['2007', 'los angeles galaxy', 'major league soccer', '24', '0'], ['2008', 'los angeles galaxy', 'major league soccer', '14', '1'], ['2009', 'seattle sounders fc', 'major league soccer', '14', '0'], ['2010', 'seattle sounders fc', 'major league soccer', '7', '0'], ['2011', 'vancouver whitecaps fc', 'major league soccer', '16', '0'], ['2012', 'chivas usa', 'major league soccer', '1', '0'], ['total', 'last updated : february 22 , 2012', 'last updated : february 22 , 2012', '221', '14']]