melissa reid
the only year that melissa reid had 0 wins and played in more than 15 tournaments is 2008 .
{'scope': 'subset', 'row': '3', 'col': '2', 'col_other': '1', 'criterion': 'greater_than', 'value': '15', 'subset': {'col': '4', 'criterion': 'equal', 'value': '0'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'wins', '0'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; wins ; 0 }', 'tointer': 'select the rows whose wins record is equal to 0 .'}, 'tournaments played', '15'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose wins record is equal to 0 . among these rows , select the rows whose tournaments played record is greater than 15 .', 'tostr': 'filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } }', 'tointer': 'select the rows whose wins record is equal to 0 . among these rows , select the rows whose tournaments played record is greater than 15 . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'wins', '0'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; wins ; 0 }', 'tointer': 'select the rows whose wins record is equal to 0 .'}, 'tournaments played', '15'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose wins record is equal to 0 . among these rows , select the rows whose tournaments played record is greater than 15 .', 'tostr': 'filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 }'}, 'year'], 'result': '2008', 'ind': 3, 'tostr': 'hop { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } ; year }'}, '2008'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } ; year } ; 2008 }', 'tointer': 'the year record of this unqiue row is 2008 .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } } ; eq { hop { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } ; year } ; 2008 } } = true', 'tointer': 'select the rows whose wins record is equal to 0 . among these rows , select the rows whose tournaments played record is greater than 15 . there is only one such row in the table . the year record of this unqiue row is 2008 .'}
and { only { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } } ; eq { hop { filter_greater { filter_eq { all_rows ; wins ; 0 } ; tournaments played ; 15 } ; year } ; 2008 } } = true
select the rows whose wins record is equal to 0 . among these rows , select the rows whose tournaments played record is greater than 15 . there is only one such row in the table . the year record of this unqiue row is 2008 .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_greater_1': 'filter_greater', 'filter_eq_0': 'filter_eq', 'all_rows_7': 'all_rows', 'wins_8': 'wins', '0_9': '0', 'tournaments played_10': 'tournaments played', '15_11': '15', 'eq_4': 'eq', 'num_hop_3': 'num_hop', 'year_12': 'year', '2008_13': '2008'}
['year', 'tournaments played', 'cuts made', 'wins', '2nd', '3rd', 'top 10s', 'best finish', 'earnings', 'money list rank', 'scoring average', 'scoring rank', 'rolex ranking']
[['2006', '1', '1', '0', '0', '0', '0', 't12', 'n / a', 'n / a', '72.33', 'n / a', '658'], ['2007', '3', '3', '0', '0', '0', '1', '9', '4050 1', 'n / a', '73.18', 'n / a', '307'], ['2008', '16', '12', '0', '3', '1', '7', '2', '136606', '12', '71.96', '26', '169'], ['2009', '14', '13', '0', '1', '2', '8', '2', '168749', '7', '71.12', '6', '128'], ['2010', '21', '20', '1', '2', '1', '10', '1', '270871', '3', '71.21', '7', '58'], ['2011', '19', '19', '2', '1', '3', '10', '1', '286578', '2', '70.83', '11', '45']]