1972 u.s. open ( golf )
in the 1972 u.s. open ( golf ) , among the players united states , 3 of them won 300 or more points .
{'scope': 'subset', 'criterion': 'greater_than_eq', 'value': '300', 'result': '3', 'col': '4', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'united states'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater_eq', '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 .'}, 'total', '300'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is greater than or equal to 300 .', 'tostr': 'filter_greater_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 }'}], 'result': '3', 'ind': 2, 'tostr': 'count { filter_greater_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 } }', 'tointer': 'select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is greater than or equal to 300 . the number of such rows is 3 .'}, '3'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_greater_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 } } ; 3 } = true', 'tointer': 'select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is greater than or equal to 300 . the number of such rows is 3 .'}
eq { count { filter_greater_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 } } ; 3 } = true
select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is greater than or equal to 300 . the number of such rows is 3 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_greater_eq_1': 'filter_greater_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'country_6': 'country', 'united states_7': 'united states', 'total_8': 'total', '300_9': '300', '3_10': '3'}
['player', 'country', 'year ( s ) won', 'total', 'to par', 'finish']
[['jack nicklaus', 'united states', '1962 , 1967', '290', '+ 2', '1'], ['arnold palmer', 'united states', '1960', '294', '+ 6', '3'], ['lee trevino', 'united states', '1968 , 1971', '295', '+ 7', 't4'], ['billy casper', 'united states', '1959 , 1966', '300', '+ 12', 't11'], ['orville moody', 'united states', '1969', '301', '+ 13', 't15'], ['gary player', 'south africa', '1965', '301', '+ 13', 't15'], ['julius boros', 'united states', '1952 , 1963', '305', '+ 17', 't29'], ['tony jacklin', 'england', '1970', '307', '+ 19', 't40']]