2007 missouri tigers football team
for the 2007 missouri tigers football team , of the players whose gain was under 100 , the only one who had a long of 18 was chase patton .
{'scope': 'subset', 'row': '9', 'col': '4', 'col_other': '1', 'criterion': 'equal', 'value': '18', 'subset': {'col': '2', 'criterion': 'less_than', 'value': '100'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'gain', '100'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; gain ; 100 }', 'tointer': 'select the rows whose gain record is less than 100 .'}, 'long', '18'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose gain record is less than 100 . among these rows , select the rows whose long record is equal to 18 .', 'tostr': 'filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } }', 'tointer': 'select the rows whose gain record is less than 100 . among these rows , select the rows whose long record is equal to 18 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'gain', '100'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; gain ; 100 }', 'tointer': 'select the rows whose gain record is less than 100 .'}, 'long', '18'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose gain record is less than 100 . among these rows , select the rows whose long record is equal to 18 .', 'tostr': 'filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 }'}, 'name'], 'result': 'patton , chase', 'ind': 3, 'tostr': 'hop { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } ; name }'}, 'patton , chase'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } ; name } ; patton , chase }', 'tointer': 'the name record of this unqiue row is patton , chase .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } } ; eq { hop { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } ; name } ; patton , chase } } = true', 'tointer': 'select the rows whose gain record is less than 100 . among these rows , select the rows whose long record is equal to 18 . there is only one such row in the table . the name record of this unqiue row is patton , chase .'}
and { only { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } } ; eq { hop { filter_eq { filter_less { all_rows ; gain ; 100 } ; long ; 18 } ; name } ; patton , chase } } = true
select the rows whose gain record is less than 100 . among these rows , select the rows whose long record is equal to 18 . there is only one such row in the table . the name record of this unqiue row is patton , chase .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_less_0': 'filter_less', 'all_rows_7': 'all_rows', 'gain_8': 'gain', '100_9': '100', 'long_10': 'long', '18_11': '18', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'name_12': 'name', 'patton , chase_13': 'patton , chase'}
['name', 'gain', 'loss', 'long', 'avg / g']
[['temple , tony', '1135', '96', '44', '86.6'], ['maclin , jeremy', '388', '13', '30', '26.8'], ['jackson , jimmy', '342', '11', '18', '23.6'], ['daniel , chase', '471', '218', '39', '18.1'], ['washington , derrick', '199', '15', '20', '15.3'], ['woods , marcus', '120', '0', '19', '20.0'], ['goldsmith , earl', '99', '7', '19', '7.7'], ['rucker , martin', '51', '1', '9', '3.6'], ['patton , chase', '35', '1', '18', '3.4'], ['alexander , danario', '36', '5', '19', '3.1'], ['coffman , chase', '8', '0', '8', '0.6'], ['saunders , tommy', '8', '11', '8', '0.2'], ['perry , jered', '0', '5', '0', '0.4'], ['team', '0', '42', '0', '4.2'], ['total', '2892', '425', '44', '176.2'], ['opponents', '2106', '397', '66', '122.1']]