2007 - 08 commonwealth bank series statistics
three of the players are listed as playing eight innings .
{'scope': 'all', 'criterion': 'equal', 'value': '8', 'result': '3', 'col': '2', 'subset': None}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'innings', '8'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose innings record is equal to 8 .', 'tostr': 'filter_eq { all_rows ; innings ; 8 }'}], 'result': '3', 'ind': 1, 'tostr': 'count { filter_eq { all_rows ; innings ; 8 } }', 'tointer': 'select the rows whose innings record is equal to 8 . the number of such rows is 3 .'}, '3'], 'result': True, 'ind': 2, 'tostr': 'eq { count { filter_eq { all_rows ; innings ; 8 } } ; 3 } = true', 'tointer': 'select the rows whose innings record is equal to 8 . the number of such rows is 3 .'}
eq { count { filter_eq { all_rows ; innings ; 8 } } ; 3 } = true
select the rows whose innings record is equal to 8 . the number of such rows is 3 .
{'eq_2': 'eq', 'result_3': 'true', 'count_1': 'count', 'filter_eq_0': 'filter_eq', 'all_rows_4': 'all_rows', 'innings_5': 'innings', '8_6': '8', '3_7': '3'}
['name', 'innings', 'runs scored', 'balls faced', 'average', 'sr']
[['adam gilchrist ( wk )', '8', '313', '318', '39.13', '98.43'], ['matthew hayden', '6', '161', '231', '26.83', '69.70'], ['ricky ponting ( c )', '8', '189', '256', '23.63', '73.83'], ['michael clarke', '7', '293', '416', '48.83', '70.43'], ['andrew symonds', '8', '100', '125', '14.29', '80.00'], ['michael hussey', '7', '189', '283', '47.25', '66.78'], ['james hopes', '7', '115', '125', '16.43', '92.00'], ['brett lee', '5', '49', '102', '12.25', '48.04'], ['mitchell johnson', '5', '21', '44', '7.00', '47.73'], ['nathan bracken', '4', '16', '43', '5.33', '37.21'], ['stuart clark', '2', '8', '10', '8.00', '80.00'], ['brad haddin', '2', '12', '44', '6.00', '27.27'], ['brad hogg', '4', '62', '100', '15.50', '62.00']]