2006 masters tournament
the average score for the top 3 players at the 2006 masters tournament was 68 .
{'scope': 'subset', 'col': '4', 'type': 'average', 'result': '68', 'subset': {'col': '1', 'criterion': 'less_than_eq', 'value': '3'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_less_eq', 'args': ['all_rows', 'place', '3'], 'result': None, 'ind': 0, 'tostr': 'filter_less_eq { all_rows ; place ; 3 }', 'tointer': 'select the rows whose place record is less than or equal to 3 .'}, 'score'], 'result': '68', 'ind': 1, 'tostr': 'avg { filter_less_eq { all_rows ; place ; 3 } ; score }'}, '68'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_less_eq { all_rows ; place ; 3 } ; score } ; 68 } = true', 'tointer': 'select the rows whose place record is less than or equal to 3 . the average of the score record of these rows is 68 .'}
round_eq { avg { filter_less_eq { all_rows ; place ; 3 } ; score } ; 68 } = true
select the rows whose place record is less than or equal to 3 . the average of the score record of these rows is 68 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_less_eq_0': 'filter_less_eq', 'all_rows_4': 'all_rows', 'place_5': 'place', '3_6': '3', 'score_7': 'score', '68_8': '68'}
['place', 'player', 'country', 'score', 'to par']
[['1', 'vijay singh', 'fiji', '67', '- 5'], ['2', 'rocco mediate', 'united states', '68', '- 4'], ['3', 'arron oberholser', 'united states', '69', '- 3'], ['t4', 'tim clark', 'south africa', '70', '- 2'], ['t4', 'retief goosen', 'south africa', '70', '- 2'], ['t4', 'phil mickelson', 'united states', '70', '- 2'], ['t4', 'geoff ogilvy', 'australia', '70', '- 2'], ['t8', 'stuart appleby', 'australia', '71', '- 1'], ['t8', 'rich beem', 'united states', '71', '- 1'], ['t8', 'chad campbell', 'united states', '71', '- 1'], ['t8', 'fred couples', 'united states', '71', '- 1'], ['t8', 'ben crenshaw', 'united states', '71', '- 1'], ['t8', 'ben curtis', 'united states', '71', '- 1'], ['t8', 'ernie els', 'south africa', '71', '- 1'], ['t8', 'david howell', 'england', '71', '- 1'], ['t8', 'billy mayfair', 'united states', '71', '- 1'], ['t8', "nick o'hern", 'australia', '71', '- 1'], ['t8', 'mike weir', 'canada', '71', '- 1']]