angela stanford
2002 was the only year that angela stanford played less than 20 tournaments .
{'scope': 'all', 'row': '2', 'col': '2', 'col_other': '1', 'criterion': 'less_than', 'value': '20', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'tournaments played', '20'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose tournaments played record is less than 20 .', 'tostr': 'filter_less { all_rows ; tournaments played ; 20 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_less { all_rows ; tournaments played ; 20 } }', 'tointer': 'select the rows whose tournaments played record is less than 20 . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'tournaments played', '20'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose tournaments played record is less than 20 .', 'tostr': 'filter_less { all_rows ; tournaments played ; 20 }'}, 'year'], 'result': '2002', 'ind': 2, 'tostr': 'hop { filter_less { all_rows ; tournaments played ; 20 } ; year }'}, '2002'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_less { all_rows ; tournaments played ; 20 } ; year } ; 2002 }', 'tointer': 'the year record of this unqiue row is 2002 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_less { all_rows ; tournaments played ; 20 } } ; eq { hop { filter_less { all_rows ; tournaments played ; 20 } ; year } ; 2002 } } = true', 'tointer': 'select the rows whose tournaments played record is less than 20 . there is only one such row in the table . the year record of this unqiue row is 2002 .'}
and { only { filter_less { all_rows ; tournaments played ; 20 } } ; eq { hop { filter_less { all_rows ; tournaments played ; 20 } ; year } ; 2002 } } = true
select the rows whose tournaments played record is less than 20 . there is only one such row in the table . the year record of this unqiue row is 2002 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_less_0': 'filter_less', 'all_rows_6': 'all_rows', 'tournaments played_7': 'tournaments played', '20_8': '20', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_9': 'year', '2002_10': '2002'}
['year', 'tournaments played', 'cuts made', 'wins', '2nd', '3rd', 'top 10s', 'best finish', 'earnings', 'money list rank', 'scoring average', 'scoring rank']
[['2001', '26', '12', '0', '0', '0', '0', 't15', '66956', '98', '73.24', '103'], ['2002', '19', '12', '0', '1', '0', '2', '2', '221857', '45', '72.37', '46'], ['2003', '21', '17', '1', '1', '0', '3', '1', '643192', '17', '71.94', '38'], ['2004', '24', '19', '0', '0', '0', '2', 't4', '297790', '39', '71.86', 't43'], ['2005', '25', '15', '0', '0', '1', '3', 't3', '272288', '44', '73.11', '69'], ['2006', '25', '20', '0', '2', '0', '3', '2', '473218', '23', '71.80', 't29'], ['2007', '24', '21', '0', '0', '2', '12', 't3', '713880', '19', '71.62', '11'], ['2008', '27', '23', '2', '1', '2', '10', '1', '1134753', '9', '71.22', '9'], ['2009', '21', '20', '1', '2', '2', '11', '1', '1081916', '10', '70.64', '11'], ['2010', '22', '19', '0', '1', '0', '7', '2', '596830', '18', '71.35', '19'], ['2011', '21', '20', '0', '0', '3', '9', '3', '1017196', '7', '71.42', '15'], ['2012', '26', '23', '1', '2', '1', '6', '1', '794294', '16', '71.51', '21']]