somerset county cricket club in 1891
in the 1891 somerset county cricket club season , among the players that had less than 10 matches , 2 of them had more than 14 innings .
{'scope': 'subset', 'criterion': 'greater_than', 'value': '14', 'result': '2', 'col': '3', 'subset': {'col': '2', 'criterion': 'less_than', 'value': '10'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'matches', '10'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; matches ; 10 }', 'tointer': 'select the rows whose matches record is less than 10 .'}, 'innings', '14'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose matches record is less than 10 . among these rows , select the rows whose innings record is greater than 14 .', 'tostr': 'filter_greater { filter_less { all_rows ; matches ; 10 } ; innings ; 14 }'}], 'result': '2', 'ind': 2, 'tostr': 'count { filter_greater { filter_less { all_rows ; matches ; 10 } ; innings ; 14 } }', 'tointer': 'select the rows whose matches record is less than 10 . among these rows , select the rows whose innings record is greater than 14 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_greater { filter_less { all_rows ; matches ; 10 } ; innings ; 14 } } ; 2 } = true', 'tointer': 'select the rows whose matches record is less than 10 . among these rows , select the rows whose innings record is greater than 14 . the number of such rows is 2 .'}
eq { count { filter_greater { filter_less { all_rows ; matches ; 10 } ; innings ; 14 } } ; 2 } = true
select the rows whose matches record is less than 10 . among these rows , select the rows whose innings record is greater than 14 . the number of such rows is 2 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_greater_1': 'filter_greater', 'filter_less_0': 'filter_less', 'all_rows_5': 'all_rows', 'matches_6': 'matches', '10_7': '10', 'innings_8': 'innings', '14_9': '14', '2_10': '2'}
['player', 'matches', 'innings', 'runs', 'average', 'highest score', '100s', '50s']
[['lionel palairet', '10', '19', '560', '31.11', '100', '1', '5'], ['john challen', '9', '16', '354', '25.28', '89', '0', '2'], ['richard palairet', '10', '17', '266', '19.00', '74', '0', '1'], ['herbie hewett', '12', '22', '388', '18.47', '65', '0', '2'], ['sammy woods', '11', '19', '330', '18.33', '50', '0', '1'], ['bill roe', '7', '12', '168', '15.27', '36', '0', '0'], ['crescens robinson', '11', '17', '196', '14.00', '55', '0', '1'], ['vernon hill', '9', '15', '184', '12.26', '31', '0', '0'], ['george nichols', '12', '21', '216', '10.28', '37', '0', '0'], ['ted tyler', '12', '20', '168', '9.88', '62', '0', '1']]