1990 pga championship
in the 1990 pga championship , among the players from united states , 2 of them had a total score of 300 each .
{'scope': 'subset', 'criterion': 'equal', 'value': '300', 'result': '2', 'col': '4', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'united states'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_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 equal to 300 .', 'tostr': 'filter_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 }'}], 'result': '2', 'ind': 2, 'tostr': 'count { filter_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 equal to 300 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 } } ; 2 } = true', 'tointer': 'select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is equal to 300 . the number of such rows is 2 .'}
eq { count { filter_eq { filter_eq { all_rows ; country ; united states } ; total ; 300 } } ; 2 } = true
select the rows whose country record fuzzily matches to united states . among these rows , select the rows whose total record is equal to 300 . the number of such rows is 2 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_eq_1': 'filter_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', '2_10': '2'}
['player', 'country', 'year ( s ) won', 'total', 'to par', 'finish']
[['payne stewart', 'united states', '1989', '284', '+ 4', 't8'], ['jeff sluman', 'united states', '1988', '297', '+ 9', 't31'], ['john mahaffey', 'united states', '1978', '298', '+ 10', 't40'], ['bob tway', 'united states', '1986', '299', '+ 11', 't45'], ['raymond floyd', 'united states', '1969 , 1982', '300', '+ 12', 't49'], ['hal sutton', 'united states', '1983', '300', '+ 12', 't49'], ['david graham', 'australia', '1979', '304', '+ 16', 't66']]