2007 open championship
in the 2007 open championship , athletes from the united states had an average score of 68.67 .
{'scope': 'subset', 'col': '4', 'type': 'average', 'result': '68.67', 'subset': {'col': '3', 'criterion': 'equal', 'value': 'united states'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'united states'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; country ; united states }', 'tointer': 'select the rows whose country record fuzzily matches to united states .'}, 'score'], 'result': '68.67', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; country ; united states } ; score }'}, '68.67'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; country ; united states } ; score } ; 68.67 } = true', 'tointer': 'select the rows whose country record fuzzily matches to united states . the average of the score record of these rows is 68.67 .'}
round_eq { avg { filter_eq { all_rows ; country ; united states } ; score } ; 68.67 } = true
select the rows whose country record fuzzily matches to united states . the average of the score record of these rows is 68.67 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'country_5': 'country', 'united states_6': 'united states', 'score_7': 'score', '68.67_8': '68.67'}
['place', 'player', 'country', 'score', 'to par']
[['1', 'sergio garcía', 'spain', '65', '- 6'], ['2', 'paul mcginley', 'ireland', '67', '- 4'], ['t3', 'markus brier', 'austria', '68', '- 3'], ['t3', 'ángel cabrera', 'argentina', '68', '- 3'], ['t3', 'michael campbell', 'new zealand', '68', '- 3'], ['t3', 'rory mcilroy ( a )', 'northern ireland', '68', '- 3'], ['t3', 'boo weekley', 'united states', '68', '- 3'], ['t8', 'kj choi', 'south korea', '69', '- 2'], ['t8', 'stewart cink', 'united states', '69', '- 2'], ['t8', 'pádraig harrington', 'ireland', '69', '- 2'], ['t8', 'miguel ángel jiménez', 'spain', '69', '- 2'], ['t8', 'tiger woods', 'united states', '69', '- 2']]