1986 u.s. open ( golf )
bernhard langer was the only non-american who won a share of the prize money .
{'scope': 'all', 'row': '8', 'col': '3', 'col_other': '2', 'criterion': 'not_equal', 'value': 'united states', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_not_eq', 'args': ['all_rows', 'country', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record does not match to united states .', 'tostr': 'filter_not_eq { all_rows ; country ; united states }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_not_eq { all_rows ; country ; united states } }', 'tointer': 'select the rows whose country record does not match to united states . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_not_eq', 'args': ['all_rows', 'country', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record does not match to united states .', 'tostr': 'filter_not_eq { all_rows ; country ; united states }'}, 'player'], 'result': 'bernhard langer', 'ind': 2, 'tostr': 'hop { filter_not_eq { all_rows ; country ; united states } ; player }'}, 'bernhard langer'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_not_eq { all_rows ; country ; united states } ; player } ; bernhard langer }', 'tointer': 'the player record of this unqiue row is bernhard langer .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_not_eq { all_rows ; country ; united states } } ; eq { hop { filter_not_eq { all_rows ; country ; united states } ; player } ; bernhard langer } } = true', 'tointer': 'select the rows whose country record does not match to united states . there is only one such row in the table . the player record of this unqiue row is bernhard langer .'}
and { only { filter_not_eq { all_rows ; country ; united states } } ; eq { hop { filter_not_eq { all_rows ; country ; united states } ; player } ; bernhard langer } } = true
select the rows whose country record does not match to united states . there is only one such row in the table . the player record of this unqiue row is bernhard langer .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_not_eq_0': 'filter_str_not_eq', 'all_rows_6': 'all_rows', 'country_7': 'country', 'united states_8': 'united states', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'bernhard langer_10': 'bernhard langer'}
['place', 'player', 'country', 'score', 'to par', 'money']
[['1', 'raymond floyd', 'united states', '75 + 68 + 70 + 66 = 279', '1', '115000'], ['t2', 'chip beck', 'united states', '75 + 73 + 68 + 65 = 281', '+ 1', '47646'], ['t2', 'lanny wadkins', 'united states', '74 + 70 + 72 + 65 = 281', '+ 1', '47646'], ['t4', 'hal sutton', 'united states', '75 + 70 + 66 + 71 = 282', '+ 2', '26269'], ['t4', 'lee trevino', 'united states', '74 + 68 + 69 + 71 = 282', '+ 2', '26269'], ['t6', 'ben crenshaw', 'united states', '76 + 69 + 69 + 69 = 283', '+ 3', '19009'], ['t6', 'payne stewart', 'united states', '76 + 68 + 69 + 70 = 283', '+ 3', '19009'], ['t8', 'bernhard langer', 'west germany', '74 + 70 + 70 + 70 = 284', '+ 4', '14500'], ['t8', 'mark mccumber', 'united states', '74 + 71 + 68 + 71 = 284', '+ 4', '14500'], ['t8', 'jack nicklaus', 'united states', '77 + 72 + 67 + 68 = 284', '+ 4', '14500'], ['t8', 'bob tway', 'united states', '70 + 73 + 69 + 72 = 284', '+ 4', '14500']]