1984 masters tournament
ben crenshaw was the only player who earned over 100000 dollars in prize money in the 1984 masters .
{'scope': 'all', 'row': '1', 'col': '6', 'col_other': '2', 'criterion': 'greater_than', 'value': '100000', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'money', '100000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose money record is greater than 100000 .', 'tostr': 'filter_greater { all_rows ; money ; 100000 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; money ; 100000 } }', 'tointer': 'select the rows whose money record is greater than 100000 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'money', '100000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose money record is greater than 100000 .', 'tostr': 'filter_greater { all_rows ; money ; 100000 }'}, 'player'], 'result': 'ben crenshaw', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; money ; 100000 } ; player }'}, 'ben crenshaw'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; money ; 100000 } ; player } ; ben crenshaw }', 'tointer': 'the player record of this unqiue row is ben crenshaw .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; money ; 100000 } } ; eq { hop { filter_greater { all_rows ; money ; 100000 } ; player } ; ben crenshaw } } = true', 'tointer': 'select the rows whose money record is greater than 100000 . there is only one such row in the table . the player record of this unqiue row is ben crenshaw .'}
and { only { filter_greater { all_rows ; money ; 100000 } } ; eq { hop { filter_greater { all_rows ; money ; 100000 } ; player } ; ben crenshaw } } = true
select the rows whose money record is greater than 100000 . there is only one such row in the table . the player record of this unqiue row is ben crenshaw .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'money_7': 'money', '100000_8': '100000', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'ben crenshaw_10': 'ben crenshaw'}
['place', 'player', 'country', 'score', 'to par', 'money']
[['1', 'ben crenshaw', 'united states', '67 + 72 + 70 + 68 = 277', '- 11', '108000'], ['2', 'tom watson', 'united states', '74 + 67 + 69 + 69 = 279', '- 9', '64800'], ['t3', 'david edwards', 'united states', '71 + 70 + 72 + 67 = 280', '- 8', '34800'], ['t3', 'gil morgan', 'united states', '73 + 71 + 69 + 67 = 280', '- 8', '34800'], ['5', 'larry nelson', 'united states', '76 + 69 + 66 + 70 = 281', '- 7', '24000'], ['t6', 'ronnie black', 'united states', '71 + 74 + 69 + 68 = 282', '- 6', '19425'], ['t6', 'david graham', 'australia', '69 + 70 + 70 + 73 = 282', '- 6', '19425'], ['t6', 'tom kite', 'united states', '70 + 68 + 69 + 75 = 282', '- 6', '19425'], ['t6', 'mark lye', 'united states', '69 + 66 + 73 + 74 = 282', '- 6', '19425'], ['10', 'fred couples', 'united states', '71 + 73 + 67 + 72 = 283', '- 5', '16200']]